Access 2010 Navigation Control

Posted on 2011-09-08
Medium Priority
Last Modified: 2014-04-22
Can I prevent the Navigation control in Access 2010 from reloading forms each time the user clicks one of the links? In other words, let's say the user is looking at a certain row or rows on one of the subforms of the Navigation control. I want them to be able to click off of that subform, go to another subform, and when they come back have the same row(s) display in the first subform. Currently when I use the Navigation control and click on another Navigation button, the current form closes and the new form opens. This is disconcerting to my users who may have been looking at specific data on the first form.
Question by:TechMommy
  • 2
LVL 15

Expert Comment

by:Simon Ball
ID: 36555988
I do not yet have access 2010, its on its way.. so i have not used the new navigation control.... it sounds like it deliberately closes the current form to open a new form though, and that is causing your problem.

A precise way to fix this would be to to store their filter data in a table, by user,  and re-apply it by user.. this will require quite a bit of code...e.g. when they do i afilter, the filterby string could be stored in a table with form name, user, filter value... and when a user opens a form, you could check for a record in the table, and if there is one, ask them if they want to re-appyl their previous filter....

It would be easier to put your own button on the form to go to the other forms, which do not close the current form....by adding a command button to your form usin the wizard, and having it open the form they want....without closing the current form.
LVL 11

Accepted Solution

TechMommy earned 0 total points
ID: 36564409
Thanks for taking the time to try to answer my question. I had thought of the filtering idea, but I was hoping that there is some trick built into the Navigation control. It is a cool control, but because of its "closing" and "reopening" behavior, it is somewhat useless to me. I had originally used the Command button method of moving from form to form, but when the users saw the look and feel of the Navigation control, they loved it.
LVL 11

Author Closing Comment

ID: 40014326
None of the answers gave me the information that I needed. I ended up abandoning the idea of using the Navigation control to accomplish my task.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

597 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