Results 1 to 2 of 2
  1. #1
    justinr12345 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2018
    Posts
    7

    How to Activate a NavigationButton on a NavigationControl in Access2016

    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 have
    Code:
    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

  2. #2
    justinr12345 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2018
    Posts
    7
    solved

    Code:
    DoCmd.BrowseTo acBrowseToForm, "Blank", "NavigationQueries3.NavigationSubform"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Open selected record - access2016
    By akika in forum Forms
    Replies: 2
    Last Post: 09-19-2018, 11:31 AM
  2. Access2016: Linking SQL Server View
    By ArviLaanemets in forum SQL Server
    Replies: 1
    Last Post: 01-25-2018, 03:41 AM
  3. Replies: 3
    Last Post: 01-23-2018, 03:21 AM
  4. Replies: 0
    Last Post: 02-15-2015, 03:36 PM
  5. How Do I: Auto Select NavigationButton?
    By RichardAnderson in forum Forms
    Replies: 8
    Last Post: 08-16-2013, 08:24 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums