Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple Parameter Values When Running Queries
- Thread starter RonCT
- Start date
RonCT
The best way is a different approach.
Create an unbound form, with an unbound text box in which you enter the value you want pulled from the query. With a command button, drive the report from that form.
For sake of example, let's call the form frmInput, and the text box txtInput.
In the various query columns, in the criteria column, put
Forms!frmInput!txtInput
Another approach, rather than hard-wiring the queries, would be to add code to the command button Where clause, that pulls in the value from the input box on the form.
Tom
The best way is a different approach.
Create an unbound form, with an unbound text box in which you enter the value you want pulled from the query. With a command button, drive the report from that form.
For sake of example, let's call the form frmInput, and the text box txtInput.
In the various query columns, in the criteria column, put
Forms!frmInput!txtInput
Another approach, rather than hard-wiring the queries, would be to add code to the command button Where clause, that pulls in the value from the input box on the form.
Tom
- Status
Similar threads
- Locked
- Question
