parameter query inout from text box in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!
 
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.
 
Back
Top