Using Controls on a Form to Specify Criteria For a Report 1

[zp162002]

I would like to use a form to allow a user to specify the criteria to be used to print a report. This report is based on a query. I would like to use text boxes on the form. The text boxes will not always be populated depending on the information the user chooses to enter. Does anyone have any examples on how this can be done?

 

[humbleprogrammer]

You can add your form inputs to your query. Add the sample code to your queries Criteria field:
=[Forms]![yourformname]![textboxnameonform]

If all of your forms inputs are not required, you should change your WHERE clause in your query to OR. Below is a sample:

SELECT Table1.*, Table1.field1, Table1.field2
FROM Table1
WHERE (((Table1.field1)=[Forms]![yourformname]![text1])) OR (((Table1.field2)=[Forms]![yourformname]![text2]));

Hope this helps.

 

[jrbarnett]

Take a look at the following FAQ I wrote on the very subject:

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=3619

John