I am getting this error message
Syntax Error (Missing Operator) in the query expression 'VendorNumber='.
Here is the line of code that is marked
IssueVar = DLookup("Issue", "Default_Reasons And Issues", "VendorNumber = " & VendorNumberVar)
I have looked at the Microsoft Access Help database and have seen the correct generic Syntax but I cannot seem to find what is wrong with this code.
Dlookup(expr, domain[,criteria])
Any suggestions?
Thanks,
Nick