How to Use Dlookup Function MS Access

Quick summary

The DLookup function in MS Access lets you retrieve a specific field value from a table or query and display it in a form control. This step-by-step walkthrough shows you how to bind a text box to a DLookup expression using the Control Source property in Design View.

Steps

1. Open your form in Design View.
2. Add a text box from the control group.
3. Go to the Data tab in the property sheet.
4. Set the Control Source property by clicking the ellipsis icon.
5. Replace [CustomerID] with the name of the target field or control on your form.
6. Click OK to confirm the DLookup expression.
7. Click the save icon to save all changes to the form.