Report through a Form

[mark_hall]

Not sure if this makes sense but....

I currently have a query which has two parameters which the users
chooses (area of business and status). This then go to a report.

Now on the form which the user sees, I would like the parameters to
become drop down lists and from the selection the query will return the
relevant results through the associated report thorugh Print Preview.

Can anyone help?

 

[Van T. Dinh]

On the Form, create 2 ComboBoxes cboBusiness and cboStatus populated with
relevant values. Also create a button for the user to open the Report in
Preview Mode.

In the RecordSource Query for the Report, just use full references to the
ComboBoxes as the Parameters for the Query. Thus, the criteria for your
Report should be something like:

....
WHERE ([Business] = Forms!YourForm!cboBusiness)
AND ([Status] = Forms!YourForm!cboStatus)

When the user clicks the CommandButton to open the Report, Access will use
the values currently selected as the parameter values for your Query /
Report.