Form Filter

[Stockwell43]

Hello,

Does anyone know of a site that can give me some examples of forms that I
can use to filter reports?

In otherwords, as an example click on a form that I can filter using two
cbo's and a date range but on the same form maybe only use the date range and
no filter through the cbo's. I want to be able to give the manager some
flexibility when pulling a report.

Thanks!!!!

 

[Allen Browne]

Try this one:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Although the example applies the filter to the form, you build the filter
string in exactly the same way for are report, and use it as the
WhereCondition for OpenReport, e.g.
doCmd.OpenReport "Report1", acViewPreview, , strWhere

 

[Allen Browne]

Excellent, Lisa. Feedback appreciated.

Presumably we are talking about:
http://allenbrowne.com/Access2007.html
which is very popular.