Solved

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

Posted on 2014-01-03
3
776 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
ID: 39754880
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
ID: 39797026
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
ID: 39809813
Suggested solution did not work.  I had to use a different method to resolve my issues.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

867 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

21 Experts available now in Live!

Get 1:1 Help Now