I have a Form [NavigationQueries3] that has a Navigation Control [NavigationControl0] with 6 NavigationButtons. The first and default tab is a blank form. The next 5 are datasheets with Click events on the NavigationButtons and when the user selects them is prompted with a input box to enter a CustomerID, however if they cancel this inputbox I want to activate the first NavigationButton, the blank form. You can visualize this as when you click on tab button 2-6 in a Navigation control it prompts you with an inputBox, if you Cancel the text box, it should auto-click to the first NavigationButton which is blank. The name of the Blank Form is "Blank".
I currently haveCode:DoCmd.BrowseTo ObjectType:=acBrowseToForm, ObjectName:="Blank", PathToSubformControl:="Me.NavigationSubform"
but it returns an error stating:
'The macro action BrowseTo requires a valid Path argument. A valid Path argument is of the form: MainForm1.Subform1>Form1.Subform1'
I cant figure out the syntax