Examples of expressions that look up values in other tables - Access

	Microsoft Office Access

Search

	Word 2007 Outlook 2007
Get up to speed

	Get your business online Get help using Office 2007
Your business

	Check for free updates
Office updates

Microsoft Office Access

» Access Home

Product Information

» Overview

» Top 10 Benefits

» See it in Action

» Compare Features

» Try Now

» Buy Now

Help and How-to

» Access 2007 Help

» Access 2003 Help

» Access 2002 Help

» Access 2000 Help

Choose your version

Training

» Access 2007 Training

» Access 2003 Training

» Access 2007 Demos

» Access 2003 Demos

Templates

» Templates for Access

Support and Feedback

» Product Support

» Send Us Your Comments

Technical Resources

» Developer Center

» Office Resource Kit

Additional Resources

» Office Marketplace

» Discussion Groups

» Access Solutions

» Access MVPs

Home > Products > Access > Access 2003 Help and How-to > Expressions > Using Expressions

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Examples of expressions that look up values in other tables

Applies to: Microsoft Office Access 2003

Use the DLookup function to look up a corresponding value in another table when writing Visual Basic for Applications (VBA) code, macros, and expressions. Note that you can't use this function in a data access page (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.) or an Access project (.adp).

Expression	Description
DLookup("[ContactName]", "[Suppliers]", "[SupplierID] = Forms![SupplierID]")	Displays the value of the ContactName field in the Suppliers table, where the value of the SupplierID field in the table matches the value of the SupplierID control on the active form.
DLookup("[ContactName]", "[Suppliers]", "[SupplierID] = Forms![New Suppliers]![SupplierID]")	Uses the DLookup function to display the value of the ContactName field in the Suppliers table, where the value of the SupplierID field in the table matches the value of the SupplierID control on the New Suppliers form.