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
Solved

Access 2010 Navigation Control

Posted on 2011-09-08
3
289 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
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 …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

809 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