Competent Performer
Windows 7 32bit 
Access 2010 32bit
Hi Guys
I have a subform that has the Expense Code from the Expense Codes Table and I want to look up the Description (yes I know its not correctly spelled in the formula but it is in the table)
=DLookUp("Expense Discription","Expense Codes","Expense Code=" & [ExpCombo])
But I keep getting "error" returned
Solved
=DLookUp("[Expense Discription]","[Expense Codes]","[Expense Code] = " & [ExpCombo])
Access Developer
Windows XP Access 2003
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Yet Another Dlookup isn't working thread
PLEASE HELP! Dlookup event not working....
Posting Permissions
Reply With Quote