Copy a Value from a text box to a query?

[Dave888]

Hi

Just wondering if it's possible to have the value someone enters in a form post to a query, and then run the query based on the value entered by the user?

Is there any genric examples of this? or could someone give me a brief idea how to do this?
The purpose for this is so that I can print a report afterwards that is based on the query with the user input. without having to manually go change the query and then run the report.

 

[boblarson]

Hi

Just wondering if it's possible to have the value someone enters in a form post to a query, and then run the query based on the value entered by the user?

Is there any genric examples of this? or could someone give me a brief idea how to do this?
The purpose for this is so that I can print a report afterwards that is based on the query with the user input. without having to manually go change the query and then run the report.

Don't worry about using the value for the query. You can open the report and actually open it based on the text box. See here for a generic report that I created and can open in any number of ways and with whatever "filter" I want:
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip