DLookup Format Issue

[ARW17]

I can't figure this one out. I keep stumbling my way through DLookups...

Please help!

x = Nz(DLookup("ID1", "AttendanceEvents", "EventDate= #" & txtRmvP & "# and USRI = ' " & fOSUserName() & " ' and (EventTypeCode = 'P' or EventTypeCode = 'SS-P' "), 0)

I'm getting a mix of errors when I try to correct it. With the version above, I get:

Missing ),] or item in query expression 'Event date = #3/31/17# and USRI = 't3arf' and (EventTypeCode = 'P' or EventTypeCode = 'SS-P' '.

 

[xenou]

Event date has a space in your error message (but no space in your code sample, which doesn't make sense).

If Event Date is the actual field name it needs brackets: [Event Date]