Reference a text box in a parameter query

[Guest]

How do I set up a form where a value entered into a textbox is the criteria
needed for my parameter query and I click on a command button to run it.
Also, is it possible to run the query to display in a list or text box with
the form open?

I know this is somewhat nonspecific but if I could have an example, that
would be great, thanks.

 

[Shaun Beane]

easy way with no code ...

open the query in design view and put the following criteria in the
appropriate field:
forms!yourformnamehere!yourtextboxnamehere

then use the command button wizard on your form to add a button that runs
the query.

if you need more explanation just ask.

Shaun Beane

 

[Guest]

Thanks it works great but is there some way to have the results show in a
listbox in my form instead of having a separate datasheet. thanks for your
assistance