I want my report to change each time I filter my table.

[Judy]

Every time I filter my table, the report never automatically updates. Is
there an automatic way to make the report update?

 

[Rick Brandt]

Every time I filter my table, the report never automatically updates.
Is there an automatic way to make the report update?

Reports have their own filtering. How you appply filters to the table
directly has no bearing on the report at all.

The most common thing to do is to open the report from VBA code using the
OpenReport method. That method has an optional WHERE clause that can be
used to apply a filter to the report.

DoCmd.OpenReport "Sales", acViewPreview,,"OrderNumber = 123456"

 

[Jeff Boyce]

Judy

If you base your report on a query, could you use criteria in your query to
"filter" your report?

Regards

Jeff Boyce
<Access MVP>