Dlookup() for NULL

[jgelpi16]

I have the below DLookup() but every time it returns null when I am sure there are records with these criteria. I have tested it without the [RecPosition] criteria and it works. What am I doing wrong here? Thanks in advance.

lngRecordID = DLookup("RecEmplID", "tblAuditTrail", "[RecEmplID] = " & lngEmplID & " AND [RecPosition] = ''")

[ajetrumpet]

perhaps the 'RecPosition' field is NOT a zero length string?? that's what you're asking for, in part.

have you tried also following the 'lngEmplID' var in the watch window?? are you sure the value is what you want when the code gets here.

[jgelpi16]

Adam,
checked all that. Ended up getting it to work with the following DLookup() finally...

lngRecordID = DLookup("RecEmplID", "tblAuditTrail", "[RecEmplID] = " & lngEmplID & " AND IsNull([RecPosition])")

[ajetrumpet]

there ya go! the record was NULL, which isn't what you were asking.