# How to Use Dlookup Function MS Access

> To use the Dlookup function in MS Access, open your form in Design View, add a text box, and go to the Data tab. Set the Control Source property using the ellipsis icon, replace the field name, click OK, and save your changes.

Canonical: https://livedemo.ai/tutorials/how-to-use-dlookup-function-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a516bab56e05a00ffe2de/preview?step=1

## Steps

1. Open your form in 'Design View'.
2. Add a text box from the control group.
3. Go to the 'Data' tab.
4. Set the 'Control Source' property by clicking the ellipsis icon.
5. Replace [CustomerID] with the name of the field/control on the form.
6. Click 'OK'.
7. Once done, click the save icon to save the changes.