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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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"
 
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>
 
Back
Top