Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2010 Navigation Control

Posted on 2011-09-08
3
Medium Priority
?
297 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

782 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