Can't find source of Error #2471

[GraeagleBill]

A very simple DLookup:

varRetAddr = DLookup("[Address]", "QReunionRoster", "[LastName] = " & LN)

varRetAddr dim'd as variant
LN dim'd as string
LN = "Barth" as seen in debug


Error:


QReunionRoster in fact contains a fields "LastName" and "Address" and the underlying query table in fact contains the name "Barth". I have no idea what the problem is? BTW I tried coding "LastName" with and without brackets.

[CJ_London]

after 840 posts, you must know about how to treat text and numbers when building a string

"[LastName] = '" & LN & "'"

[GraeagleBill]

"OUCH" ................ duly admonished.

[CJ_London]

Sorry, was a bit grumpy last night -