User defined Criteria from a form

[Chrishill]

Hello,

I would like to have the user select (from a drop down list) the parameters for a report.

I have been sucessful doing this through a queria and setting the criteria, where a pop up asks the user to enter the parameter. I want to get multiple paramaters from two or three drop down menu on a single form.

 

[ScottGem]

Hello,

I would like to have the user select (from a drop down list) the parameters for a report.

I have been sucessful doing this through a queria and setting the criteria, where a pop up asks the user to enter the parameter. I want to get multiple paramaters from two or three drop down menu on a single form.

You can reference a value in a control on an open form using the syntax:

=Forms!formname!controlname

So you can create a form, with controls to select/enter criteria. You then set the criteria in your query as shown. Base a report on the query and add a button to the form to run the report.