form input used in a query

[cterjesen]

I'm sure this is a simple question. I want to have a form where the user can input something into a text box and this input value is used at the criteria in a query.

I have multiple queries that are asking for the same criteria over and over again. I thought if this infomation could be captured on the form one time and fed to each query this would make the database much more user friendly.

I'm also open to using a combo box or drop down list if that's easier.

thanks!

 

[jobb]

in the criteria of your query, put:

[forms]![yourformname]![yourcontrolname]

where controlname could be a text box or combo box

 

[cterjesen]

How do I get the form to save the data input in the form's text boxes when I close out of the form and then come back in? Can I have the user's inputs feed to a table that can then be used in the queries?

Thanks!

 

[bat17]

Assuming that the form is unbound you could create a table to hold the criteria and use it as the record source for the form.
You could either force the table to have just one record so that the last used criteria is there when the form is opend or you could save each combination as a new record and just browse for the one you want.

Peter