How to Use Dlookup Function MS Access
- George Apostolov
How to Use Dlookup Function MS Access: step-by-step guide
Open your form in 'Design View'.
Add a text box from the control group.
Go to the 'Data' tab.
Set the 'Control Source' property by clicking the ellipsis icon.
Replace
[CustomerID]with the name of the field/control on the form.Click 'OK'.
Once done, click the save icon to save the changes.
Quick answer: 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.
About this tutorial
Configure the Dlookup function in the app by adding a text box, setting the control source, and saving changes. This guide shows how to use Dlookup Function MS Access in 7 steps, starting with "Open your form in 'Design View'" and finishing with "Once done, click the save icon to save the changes". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to use Dlookup Function MS Access?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
