My textbook gave me this expression to enter in a text box:
=DLookup(“[Disclaimer]”,“StandardText”,”[DisclaimerID]=”&1)
Access 2007 says it's invalid. Do you know where I'm going wrong???
Thanks!!!
My textbook gave me this expression to enter in a text box:
=DLookup(“[Disclaimer]”,“StandardText”,”[DisclaimerID]=”&1)
Access 2007 says it's invalid. Do you know where I'm going wrong???
Thanks!!!
How about: =DLookup(“[Disclaimer]”,“StandardText”,”[DisclaimerID]=1")
Access2000 get a syntax error also.
The problem is the quote character you used.
This errors
=DLookup(“[Disclaimer]”,“StandardText”,”[DisclaimerID]=”&1)
This does not error
=DLookup("[Disclaimer]","StandardText","[DisclaimerID]="&1)
This does not error
=DLookup("[Disclaimer]","StandardText","[DisclaimerID]=1")
Try changing/replacing the quote character.
You got it! Thank you so much!
Good catch Steve.