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.
Parameter Queries (1 Viewer)
- Thread starter clauses
- Start date
TessB
Plays well with others
- Local time
- Today, 07:45
- Joined
- Jan 14, 2002
- Messages
- 906
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
=[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
