Access 2007 and Filtering

[David1129]

I'm working on testing a large application with Access 2007. It has been running under 2003 and XP with no obvious errors.

However with 2007 many forms seem to have lost the ability to filter. When the form is loaded, the record source specifed, a filter applied, and filtering set to on, either no records are displayed, or ALL of the records displayed.

Click on the "Toggle Filter" on the ribbon and voila, the resordset is displayed.

It's acting like there's an Access Option that says "Disable Programmatic Filter switch"

The code is shown below
/CODE/
Me.Filter = sBuildFilter
Me.FilterOn = True
' Save Filter info for report
SaveSetting APP_NAME, ROUTINE_NAME, "Filter", sBuildFilter
txtFilter = sBuildFilter
Me.Requery
/CODE/

Putting a Watch on "Me.FilterOn" shows TRUE when run in 2003, but remains FALSE when run under 2007. Same results when FilterOn is moved up a line.

Anyone working with the 2007 beta having similar problems

Dave

[MMcCarthy]

There are always filter problems and they seem to occur a lot during version changes. Me.Filter = "" has been known to turn a filter off so in your example if sBuildFilter = "" it could be turning the filter off.

I haven't done any work in 2007 yet but I know they have been doing a lot of work on filters.

Check out this blog ...

http://blogs.msdn.com/access/archive...11/595718.aspx

I'm working on testing a large application with Access 2007. It has been running under 2003 and XP with no obvious errors.

However with 2007 many forms seem to have lost the ability to filter. When the form is loaded, the record source specifed, a filter applied, and filtering set to on, either no records are displayed, or ALL of the records displayed.

Click on the "Toggle Filter" on the ribbon and voila, the resordset is displayed.

It's acting like there's an Access Option that says "Disable Programmatic Filter switch"

The code is shown below
/CODE/
Me.Filter = sBuildFilter
Me.FilterOn = True
' Save Filter info for report
SaveSetting APP_NAME, ROUTINE_NAME, "Filter", sBuildFilter
txtFilter = sBuildFilter
Me.Requery
/CODE/

Putting a Watch on "Me.FilterOn" shows TRUE when run in 2003, but remains FALSE when run under 2007. Same results when FilterOn is moved up a line.

Anyone working with the 2007 beta having similar problems

Dave