=========
QUESTION
———
How do I use the value from the field of one table as the criteria in a query against a different table?
How do I use the DLookup function?
=========
ANSWER
———
See EXAMPLES
=========
EXAMPLES
———
Number Fields:DLookup("FieldName" , "TableName" , "Criteria = n")
Text Fields: DLookup("FieldName" , "TableName" , "Criteria= 'string'")
Date Fields: DLookup("FieldName" , "TableName" , "Criteria= #date#")
You can also skip the Criteria portion altogether: DLookup("FieldName", "TableName")
=========
APPLIES TO / KEY WORDS
———
Microsoft Access
DLookup
Functions
Lookup
Look up
=========
REF
———
http://www.techonthenet.com/access/functions/domain/dlookup.php
—
http://www.anysitesupport.com/access-dlookup/
http://anySiteHosting.com