Query Criteria Dlookup (1 Viewer)

[jmaty23]

I am trying to run a query and filter it by the current authorized user id in my database.

=DLookUp("property","tblwoOption","[userid] = #" & auth.userid & "#")

auth.userid is in a class module that should show the current user id number and for some reason it isn't working. When I try to run the query, the Enter Parameter Value box shows with auth.userid. Is it possible to call these in query criteria's?

 

[pr2-eugin]

jmaty23, you have enclosed the criteria with ## which is normally used for Dates.. so try this..

=DLookUp("property","tblwoOption","[userid] = " & auth.userid)

 

[jmaty23]

I copied what you said it should be and the query changed it to this:

=DLookUp("property","tblwoOption","[userid] = " & [auth].[userid])

When I try to run the query, I still get the Enter Paramater Value box.

 

[Pat Hartman]

What is [auth]? If you are trying to reference a control on the active form, use Me.UserID.