How to Use Dlookup Function MS Access

‍

‍

Here’s how to do it:

‍

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.