FrankZwolinski
asked on
Access 2010 Navigation Form - Allow for multiple sub forms.
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?
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?
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
How did you create it?
Is it from this site?
http://accessextra.blogspot.com/2010/04/in-access-2010-venerable-native.html
ASKER
Yes. It is a new type of form that has a navigation control and a sub form.
It is new to Access 2010.
It is new to Access 2010.
ASKER
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.
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.
Yes sorry, I did not know about this Navigation Form, while I have not Access 2010 yet.
My fault ...
My fault ...
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.
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.
ASKER
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?
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?
Please do
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
(that may be a dumb question!)
See the file link below the block where you enter comments?
Click it and give 'er
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
Me!NavigationSubForm.Visib
Me!NavigationSubForm.Visib
HTH,
Daniel