Solved

Access 2010 Navigation Control

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Balance After Payment 12 62
Handle Apostrophes in VBA SQL - Part 2 10 48
2 Global Vars, 1 List Box 4 34
Access VBA for Search Engine 7 16
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…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

752 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