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.

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