Solved

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

Posted on 2014-01-03
3
767 Views
Last Modified: 2014-01-26
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
0
Comment
Question by:dhemple
  • 2
3 Comments
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
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)
0
 

Accepted Solution

by:
dhemple earned 0 total points
Comment Utility
I was unable to get the suggested solution to work and had many other issues with Navigation Sub form that followed.  As a result, I scraped the use of Navigation Sub forms and create my own navigation sub forms.  In doing so, users are no longer prompted to save the form as they were previously.

Thank you.
0
 

Author Closing Comment

by:dhemple
Comment Utility
Suggested solution did not work.  I had to use a different method to resolve my issues.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now