Filtering Report data by form ??

[cdacey]

Hi,
After reading many books on Access, I am still not able to find a way to filter report data using a form. I know you can use the parameter [prompt for value] in a query, but when you want to allow a user to filter on several field values, having multiple pop-up parameter prompts just looks sloppy. Any thoughts ? I must be missing something .

Thanks Chris

 

[Mile-O]

A form with the options you'd want to filter on it and a command button to run the report.

On the click of the button you make the form invisible and open the report.

The report is based on a query. That queries criteria, rather than parameter boxes, reference the controls decide by the user on the form.

On the close of the report, make the form visible again.

 

[Autoeng]

Check out the report filter utility (RFil) at www.mile50.com

 

[cdacey]

Thansk

Thanks Guys, I will try both ideas !