A very simple DLookup:
varRetAddr dim'd as variantCode:varRetAddr = DLookup("[Address]", "QReunionRoster", "[LastName] = " & LN)
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.