the Dreaded DLookUp (XP)

Topic

New Reply

I just can’t get the syntax right, trying to look up a text field to return the long integer ID – here’s where I’m up to –
lngAtt_ID = DLookup(“Att_ID”, “tblAttendees”, “External_ID = “””” & strExternal_ID & “””)
External_ID is a unique text field. What am I getting wrong?

Now I’ve got it – lngAtt_ID = DLookup(“Att_ID”, “Attendees”, “External_ID = “”” & strExternal_ID & “”””) – Hooray!

Reply | Quote

Replies

BTW, when you are trying to embed quotes in a string, you might find it easier to read if you tried embedding a single-quote rather than a double-quote.

So instead of:   lngAtt_ID = DLookup("Att_ID", "Attendees", "External_ID = """ & strExternal_ID & """") - Hooray!

you would have:  lngAtt_ID = DLookup("Att_ID", "Attendees", "External_ID = '" & strExternal_ID & "'") - Hooray!

Reply | Quote

That is much easier to remember – thanks

Reply | Quote