asked on

Access 2007 - 2010 Applied Form Filter Prompting User to Save Form

Hello Experts.

The below code works. However, when I move to another tab within the navigation form I get a message asking me to save the form. The filter within the form changes to whatever I entered in the [txtSearchBrandName] control and therefore prompts me to save.

Is there a way around this? I'm not so interested in saving the changes, but if I have to I would like to do so without a prompt to the user.

Thank you.

DoCmd.ShowAllRecords
Forms![MainMenu].Form![NavigationSubform].Form![frm_PremierProductLaunchPlanner_SubFrm_FDB].Form.Filter = "[FDB_BrandName] Like '*" & Forms![MainMenu].Form![NavigationSubform].Form![frm_PremierProductLaunchPlanner_SubFrm_FDB]![txtSearchBrandName] & "*' "
Me.Form.FilterOn = True
Requery
Me![txtSearchBrandName] = ""
Me![txtSearchBrandName].SetFocus

mbizup

From what I've seen, browsing other similar threads, this sounds like a bug with navigation forms and tables or subforms in datasheet view, and which others seem to have worked around by strategically placing

Docmd.SetWarnings False

and ensure that at some point in there code there is a corresponding

Docmd.SetWarnings true

(Untested by me - just something I've seen in similar threads)

ASKER CERTIFIED SOLUTION

dhemple

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dhemple

ASKER

Suggested solution did not work. I had to use a different method to resolve my issues.