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
- Open your form in Design View.
- Add a text box from the control group.
- Go to the Data tab in the property sheet.
- Set the Control Source property by clicking the ellipsis icon.
- Replace [CustomerID] with the name of the target field or control on your form.
- Click OK to confirm the DLookup expression.
- Click the save icon to save all changes to the form.
