Using Navigation Control

[PlamenGo]

Sorry if repeating some thread, but I could not find solution ....
I am using the new 2010 Navigation Form and need select the next (1>2, 2>3) button programatically ... i.e after performing some operations in the Subform, linked to NavButton1, to perform to open the Subform , linked to NavButton2 ... etc. as if as I have clicked NavButton 2.

My code (that does;t work is:

Forms!NavigationForm.Forms.Navigationbutton2_click
Pleas, help

[June7]

Try:

Forms!NavigationForm.Navigationbutton2_Click()

or

http://bytes.com/topic/access/answer...n-another-form

[PlamenGo]

Thanks for the prompt response, but it does't work this way. even I tried to call the _Click from the NavForm, but it does not work. The NavigationForm has no code (I mean code I can access). Obviously there is some hidden event ....

[PlamenGo]

Forgot:
The Error Message is "Sub or Function not defined!"

[June7]

Oh, yeah, I forgot that the NavigationForm wizard builds embedded macros. I don't use macros and avoid wizards. Might have to convert macros to VBA for what you want to do.

[PlamenGo]

Of course, but there is a small problem (for me) - I cannot see the macro ....

[June7]

Wait, I just tested building a navigation form. It did NOT create macros, didn't create any VBA procedures either. Look at the Click event of a tab of the navigation assembly. Anything in there?

[PlamenGo]

no, and that makes me .... thank you for the attention, I have to go to bed - it's 2AM here ... I will have to write to MS tomorrow ... or try to find another solution - the simplest is to disable all controls in the subform and trigger a message "Press tab 2 to continue", although I was trying to avoid this ....

[June7]

Need to write code to go with the button. Select [Event Procedure] in the event property. Double click the ellipses (...) and that will put you in the procedure in the VBA editor.

[PlamenGo]

I asked MSA (answers.microsoft.com) and got a reply that resolved my problem:

"Use the browseto command.
If you browseto a form that is included in the nav buttions, then that one becomes active.

eg:

DoCmd.BrowseTo acBrowseToForm,"Form3","Navigation Form.NavigationSubForm", "where condition"

Note that if in say a choice of 5 nav buttons, you do NOT have form3 (as in the above example) then the current existing sub form will be replaced. However, if the 4th button is set to form3, then the above would display form 3, and the 4th button would highlight.
And, as the above shows, you can add in a where clause.
The above browse to command of course is available in both VBA as above, or as a macro command.
This navagation feature is for web forms, but is a great choice for desktop also."

Hope this to be useful for other developers too.