[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Access 2010 Navigation Form -  Allow for multiple sub forms.

Posted on 2011-05-11
13
Medium Priority
?
288 Views
Last Modified: 2016-06-03
The Navigation Form is a fresh change to the old switchboard, but it lacks the ability to keep more than one form open without opening another window or tabbed document.

Many of my clients like to have multiple forms open. The Navigation form displays only one form at a time. Every click of a menu loads a new form to the Navigation sub form control.

I am able to add multiple Navigation sub forms i.e NavigationSubForm (default), NavigationSubForm2, NavigationSubForm3, NavigationSubForm4, NavigationSubForm5, NavigationSubForm6. I am unable to find the events on the Navigation form that allows me to hide and unhide the sub forms using the visible property of the sub form.  I have attempted to use the lost focus, on-click events of the Navigation control but I can't  get the form to behave as I would expect.

Has anyone tackled this issue?
0
Comment
Question by:FrankZwolinski
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 12

Expert Comment

by:danishani
ID: 35743721
You can use the .Visible property of your subform to hide/unhide;
Me!NavigationSubForm.Visible = False 'Hide
Me!NavigationSubForm.Visible = True  'UnHide

HTH,
Daniel
0
 
LVL 26

Expert Comment

by:Nick67
ID: 35743736
I am not sure what you mean by the Navigation Form
How did you create it?
Is it from this site?
http://accessextra.blogspot.com/2010/04/in-access-2010-venerable-native.html
0
 

Author Comment

by:FrankZwolinski
ID: 35743746
Yes. It is a new type of form that has a navigation control and a sub form.
It is new to Access 2010.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

Author Comment

by:FrankZwolinski
ID: 35743772
I understand the syntax to hide a sub form.  
My question is which events in the navigation control can I use to hide or unhide the subform as  I click various menu's.
The on-click of the Navigation control does not work.
0
 
LVL 12

Expert Comment

by:danishani
ID: 35743779
Yes sorry, I did not know about this Navigation Form, while I have not Access 2010 yet.
My fault ...
0
 
LVL 26

Expert Comment

by:Nick67
ID: 35743946
You're in the weeds, dude
Have a look at the bottom of this post
http://msdn.microsoft.com/en-us/library/ff851947.aspx

Where the normal tab control actually LOADS everything, a navigation form does NOT.
Which might mean that it UNLOADS everything when you click on a different nav option.

There may be nothing to hide or unhide or reference.
WYSIWYG apparently.
0
 

Author Comment

by:FrankZwolinski
ID: 35745999
I am aware of the article you just posted. Thanks. I may not be communicating my question clearly.

Let me illustrate step by step.
1. Click on Customer menu
2. Customer form displays first record - AAA Company.
3. Filter for ZZZ Company
4. Click on another menu like Invoices
5. Click back to Customer menu.
6. The customer form shows AAA Company.
That is because the sub form was unloaded when I clicked on another menu. The Customer form is reloaded and shows first record.

I want to enhance the default Navigation Form which has ONE sub form by adding 5 more sub forms.
I want to control special forms that I  DO NOT want to unload when moving to another menu.  Certain forms that I select should always remain open in one of the 6 sub forms. It would work as if I had 5 tabbed documents open, as I click through each tabbed document, the form, report or query remains loaded until I close the tab.


There are many compelling reasons to having this functionality. Many users work on multiple tasks / forms  simultaneously. They should not have to re-filter or type key strokes to get to the record set they want to view every time they click on a menu option.  If a user begins entering a new customer record and fills out 20 of 30 fields and then needs to print a quick report for the boss, they can possibly loose the data if there is validation in place and the form is unloaded.  Not a happy situation.


Since this Navigation control is new to 2010, it does not behave like other controls. The events related to the control don't fire.  If they did, it would be easy to code the  visible and not visible properties of each sub form depending on the menu being clicked. I was hoping that someone may have found a workaround to this issue.

I hope my questions is more clear. Thanks for all your replies.

Can I post a database sample?
0
 
LVL 26

Expert Comment

by:Nick67
ID: 35747767
Please do
0
 
LVL 26

Expert Comment

by:Nick67
ID: 35747839
You know how?
(that may be a dumb question!)
See the file link below the block where you enter comments?
Click it and give 'er
0
 

Accepted Solution

by:
FrankZwolinski earned 0 total points
ID: 35766610
I found a solution. The on-click event can be trapped for each menu item (button)
First remove the form name from the Navigation Target Name properly of the navigation control.
Second, add as many sub forms as needed. Just copy NavigationSubForm  and lay all the sub forms on top of one another.
NavigationButton1, NavigationButton2,  NavigationButton3
NavigationSubForm,  NavigationSubForm2,  NavigationSubForm3

NavigationButton1_OnClick
'load the sub form only if the source object is blank otherwise just display the sub form.
if nz(me.NavigationSubForm.SourceObject)  <> "CustomerForm" then
    me.NavigationSubForm.SourceObject="CustomerForm"
end if
me.NavigationSubForm.Visible=True
me.NavigationSubForm2.Visible=False
me.NavigationSubForm3.Visible=False

A close button on any of the subforms would be as follows:
me.NavigationSubForm.SourceObject=""


Since I understand how it works now, I am going to design a tool that programmatically creates all the subforms and code to accomplish the desired result.

0
 

Expert Comment

by:EE_AutoDeleter
ID: 41629042
I've requested that this question be deleted for the following reason:

                           
No comment has been added to this question in more than 21 days, so it is now classified as abandoned and is now flagged for deletion.


If there is a valid solution, please OBJECT and indicate the comments that are, or would otherwise lead to, a solution.


Use the specific format https:#axxxxxxxx for comment ID(s).


Also, please don't object simply because the author did not respond to your comment. While we understand this is frustrating, unfortunately we cannot force the author to return to the question. Unless you feel you have presented a valid, verifiable solution we'll simply delete the question.


Experts-Exchange Auto Deleter
0
 
LVL 26

Expert Comment

by:Nick67
ID: 41629043
Author's comment https:#a35766610 as the answer.
Points as you see fit.

Nick67
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Implementing simple internal controls in the Microsoft Access application.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
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…

590 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