Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

You can’t use Apply/Filter action on this window?

Status
Not open for further replies.

JGravesNBS

Programmer
Mar 20, 2003
5
US
I’m using A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8 WinXp SP2

I’m opening/running a Access 2000 FE.mdb with Access 2007.

I have a report with subreports and get the following message twice during the report preview:

===================================
You can’t use Apply/Filter action on this window.

* You tried to use the Apply/Filter action or method, but you didn’t apply the filter to a table, query, form or
report.

* You may have applied the filter to a form, but the form wasn’t open in Form or Datasheet view.

* You may have applied the filter to a report, but didn’y use the Apply/Filter action in a macro specified by the
OnOpen property setting.

Use the SelectObject action or method to select the table, query, form or report before applying the filter.
OK
==================================================

When I click OK to the 2 messages the report continues and completes and looks OK

This same report has worked OK for years with no messages on a2k thru a2k3 computers

I checked the Report in design view and all Report and all SubReport’s the Filter is empty and Filter On = No

Where should I start looking?

Thanks, John

PS: AutoCorrect is off
Reviewed all suggestion and processed all SP1 and all Hotfixes mentioned on:
Allen Brown Tony Toews
11397335
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top