Query Results Based on UserID

[DanG]

Hello,

I have a query (used in a combox) with a field called "UserID" and in the query I would like to have the UserID field get it's criteria from the "User" field on a hidden form.

I have it for the most part however, I have two users (myself and another) that when we use the combo box we se "All" the records in the query.
I was thinking something like:

IIf([Forms]![frmUser]![user]= [User],true, "*")

I hope this makes sense.

Thank you

 

[DanG]

Maybe making the question more simple will help

In my query the UserID gets the criteria from the reference to the hidden form. In the event that there is "NOT" a match I would like the default to be to show "All" records.

Currently the query only runs when there is a match.

HTH.

 

[DanG]

I figured it out.

It all came down to how to use "Like" in an "IIF" statement.
I was trying "IIF(UserID="R12345","R12345",Like "*")
When I should have been using "Like IIF(......)"
Never knew that!

http://www.access-programmers.co.uk/forums/showthread.php?t=130047&highlight=iif+wildcard