Report Filter

[BFlat]

I have a table that has two types of facilities: A and B. In my db I run multiple reports that use the facility info via a query. I just realized that there will be times that I need to run reports off the facilities seperately. In light of not having to reproduce 15 diferrent queries and subsequently reports, is there a way I can have a button on the form that I can click to limit the results a certain type?

[RuralGuy]

The WhereCondition argument of the OpenReport command applies a filter to the Report and does a very good job of it.

[BFlat]

So I can understand correctly....

I have a form filter "ABC" that opens report "123" based on parameter input. The report is souced by query "XYZ". In the date field of query "XYZ" I have Between Forms!ABC!txtStart And Forms!ABC!txtEnd where txtStart and txtEnd are parameter entry fields on the "ABC" filter form.

On the form "ABC" the code that opens report "123" has the following:

Private Sub Sum_Click()
DoCmd.OpenReport "Total", acViewPreview
End Sub

What code would I place an additional button to say where facility type is = to A? Sorry, I'm a little slow at this.

[RuralGuy]

Sorry but I've been gone all day. From Help:
expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

...you can see that the 4th argument is a WhereCondition argument. It could be something like:

DoCmd.OpenReport "Total", acViewPreview, , "Type = 'A'"
...or...
DoCmd.OpenReport "Total", acViewPreview, , "Type = '" & YourStringVariable & "'"

BTW, "Type is a RESERVED WORD in Access and should not be used by you as a name of an object.
http://www.allenbrowne.com/AppIssueBadWord.html#T