Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need Help with a Dlookup
- Thread starter ChemistZ
- Start date
- Thread starter
- #3
To update the TT thread. I have reviewed your DLookUp statement:
=DLookUp("[FunctionName]","frmGenFunctions","[FunctionID] =" & [Forms]![frm2-4FunctionDetails]![FunctionID])
The domain from your statement is trying to perform a lookup of a domain frmGenFunctions. A domain can only be a table or a query. The updated statement below should work for you as I have changed the domain to your table name.
=DLookUp("[FunctionName]","GenFunctions","[FunctionID] =" & [Forms]![frm2-4FunctionDetails]![FunctionID]) Bob Scriver
=DLookUp("[FunctionName]","frmGenFunctions","[FunctionID] =" & [Forms]![frm2-4FunctionDetails]![FunctionID])
The domain from your statement is trying to perform a lookup of a domain frmGenFunctions. A domain can only be a table or a query. The updated statement below should work for you as I have changed the domain to your table name.
=DLookUp("[FunctionName]","GenFunctions","[FunctionID] =" & [Forms]![frm2-4FunctionDetails]![FunctionID]) Bob Scriver
- Status
Similar threads
- Locked
- Question
