SteveL13
asked on
How use DLookup on a report
I have a text box on a report and am trying to do a DLookup for it. Here's is what I have in Control Source but it's not working.
=DLookUp("[CapCat]","tblCa pacityCate gory","[Ca pCat] =& [txtCapCat]")
????
=DLookUp("[CapCat]","tblCa
????
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FYI, unless it's for some totally un-related data, you should avoid the use of Dlookup(). Instead, modify the query the report is based on and include the table(s) with the info you need.
JimD.
ASKER