ACC2000: How to Use DLookup to Look Up Values in Forms or Reports (209743)
The information in this article applies to:
This article was previously published under Q209743 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
SUMMARY
You can display multiple fields in a combo box or a list box on a form or a report even when those fields come from a table that is not bound to the form or report. You can also update controls, such as text boxes, with new
information based on what a user selects from a combo box or a list box.
To accomplish these objectives, you could use one of the following
techniques:
- Use AutoLookup in forms.
- Use multiple DLookup() functions in forms and reports.
- Use the Column property of a multiple-column combo box to update a text box control with new information as focus moves from row to row in the combo box.
This article shows you how to use the DLookup() function to look up values in forms or reports.
REFERENCES
For additional information about the DLookup() function, please see the following article in the Microsoft Knowledge Base:
208786 ACC2000: DLookup() Usage, Examples, and Troubleshooting
For more information about the DLookup() function, click Microsoft Access Help on the Help menu, type DLookup function in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 12/12/2002 |
---|
Keywords: | kbdta kbhowto KB209743 |
---|
|