Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-01-03
3
Medium Priority
?
818 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 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