Sivasan
asked on
Pass criteria from a value on text box in access form to a query to pull exact match result or All when left blank
Hi There,
I'm trying to pass a criteria in an MS access query from a text box in form. What I like to do is check exactly for the value user enter in the text box( i don't want similar value of what user enters, say if the user enters ABC, I want result eactly matching ABC, not like ABC such as ABC , ABCD, ABCDE etc, if they leave it blank( if needed I can use something like "ALL") then pull everything.
On the query I have it like this [FORMS]![usrpartform]![usr Part] OR Like "*" but it always pulls everything.
I would appreciate if you could tell me the exact syntec to be used on the query to get the result as desired.
Thks
I'm trying to pass a criteria in an MS access query from a text box in form. What I like to do is check exactly for the value user enter in the text box( i don't want similar value of what user enters, say if the user enters ABC, I want result eactly matching ABC, not like ABC such as ABC , ABCD, ABCDE etc, if they leave it blank( if needed I can use something like "ALL") then pull everything.
On the query I have it like this [FORMS]![usrpartform]![usr
I would appreciate if you could tell me the exact syntec to be used on the query to get the result as desired.
Thks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Dale.
Thanks a million.Worked good.
Thanks
Thanks a million.Worked good.
Thanks
Glad to help.
Open in new window