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>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Can't create a report from my query in Access 1
Storing Multiple Selected Pivot Table Report Filter Values 2
Printing reports 1
Report page break problem 2
Access Access 2010: Activating controls in a form after filter by form 0
Print reports with creteria - 2 questions.. 1
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top