JeffNolan1900
Technical User
I am trying to store the value of a form text box inside a query criteria, but I do not want to load the value of the textbox when the query opens, I want the value to be written in to the query criteria, thru vba, permanatly. As in stored as the value, so when the form is closed, the value is still stored inside the query criteria box.
What code would I use to send a value to the query criteria box?
Ex:
Form Text box: Jim
(user click submit button)
value 'Like "*" & Jim & "*"' is written to the query criteria for user name field.
the query is then opened using the vba cmd: DoCmd.OpenQuery
The piece in italics is what I am having trouble with
Any ideas?
What code would I use to send a value to the query criteria box?
Ex:
Form Text box: Jim
(user click submit button)
value 'Like "*" & Jim & "*"' is written to the query criteria for user name field.
the query is then opened using the vba cmd: DoCmd.OpenQuery
The piece in italics is what I am having trouble with
Any ideas?