Solved

Access 2010 Navigation Control

Posted on 2011-09-08
3
278 Views
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.
0
Comment
Question by:TechMommy
  • 2
3 Comments
 
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.
0
 
LVL 11

Accepted Solution

by:
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.
0
 
LVL 11

Author Closing Comment

by:TechMommy
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.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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