parameter query inout from text box in form

[Guest]

i want to use a parameter query to look up a clients details, however i want
to use the criteria for the pamameter query from a text box in a form. I
waould type in the surname of the client and hit go. I want this instead of
having the input box appear for the criteria... ANY HELP PLEASE!!!

 

[Allen Browne]

In the Criteria row of your query, name the parameter the same as you would
reference a form, e.g.:
[Forms].[Form1].[Text0]

It is also a good idea to declare your parameters by selecting Parameters on
the Query menu. In the dialog you enter the full name, and the type of data,
e.g.:
[Forms].[Form1].[Text0] Date/Time
This helps Access interpret the type of data correctly.