Access 2007 ApplyFilter

By ltait ·
I have a problem with Access databases created in Access 2000 but now using Access 2007

I have a combo box on a form listing all people a filter is applied to the data on the form when a person is selected from the box. The Event AfterUpdate uses the code DoCmd.ApplyFilter , "[MemberId] = Forms!frmMembers!FindMember" to show the selected person.

This works fine once (and has always worked in previous versions of Access) but if you select another person their details are not displayed. Closing the form and reopening the filter works once and then doesn't display the seconf selection. Any ideas?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

ApplyFilter Macro in Access 2007 Not Working

by Robert_1980 In reply to Access 2007 ApplyFilter

Hi Itai,
I had the same problem with several Access databases which we had built for our company several years ago and worked flawlessly over previous incarnations of Access, from Access 2000 to Access XP and Access 2003.
However, on upgrading our PC's to Access 2007 all our search features stopped working. After struggling with this bug for several weeks we finally found a developer at OfficeSoftworks who fixed this bug on all our databases. Their number is 0784 219 4018 (ask for Jake he is the actual developer who found the solution for our bug!) You can find them on any of those sites:

Hope this comes useful,

Related Discussions

Related Forums