Parameter Queries

[clauses]

I currently use a form to enter search criteria and am having trouble passing the value I enter into a textbox to my query. Everytime I press my search button it ask me for the parameter regardless of what I have entered in the textbox. How do I structure my query to accept the parameter from the form and not utilize its own dialog box.

 

[TessB]

In your query, on the field that you want to pass the parameter to, in the criteria space, type

=[NameOfForm]![NameOfField]

So, if you are taking information from say the txtName field on the frmDataEntry form, your criteria would look like this

=[frmDataEntry]![txtName]

play with your query a little bit.... in the criteria space, right click and select build expression. You may be interested in seeing that tool. I know it helped me tremendously with syntax. (If you are interested.)


Tess