Results 1 to 5 of 5
  1. #1
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130

    Exclamation Navigation Form issues

    I am attempting to set up a navigation form for my "New Employee" form. I want to have a tab for the employee's information, another for device information, and so on. When I get the form inside of the navigation form to load, how do I get it to go straight to a new record. For example, Navigation form is named frmNewEmployee and the form on the employee information tab is called frmAddEmployee.

    I've tried:



    Macro - open form -> frmAddEmployee -> goto record new (receives error stating that form is not open)
    Macro - open form -> frmNewEmployee -> goto record new (no error, but does nothing)

    Attempted to write the VBA for doing the same thing above and get same results. What am I doing wrong?

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Once you place a Form within the native Navigation Form, the Form actually becomes a Subform, and has to be addressed/referred to as such. Very few experienced developers use the Navigation Forms, for this reason; most of us 'roll our own' nav forms.

    Linq ;0)>

  3. #3
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    Thank you for the information. What would be the best way to learn how to "roll my own" nav form? haha

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    That would usually be using a Tab control and placing subforms on each page of the Tab control.

    You might find this of interest http://www.datapigtechnologies.com/f...loredtabs.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    India
    Posts
    616
    As mentioned above , once inserted, nav forms are like sub form.
    Put this code in the Click event of Navigation Button that opens your (inserted) form.
    Code:
    Me.NavigationSubform.SetFocus
    DoCmd.GoToRecord , , acNewRec

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

Similar Threads

  1. Replies: 1
    Last Post: 11-18-2014, 12:35 PM
  2. Replies: 5
    Last Post: 11-04-2014, 08:13 AM
  3. Replies: 12
    Last Post: 10-23-2014, 02:08 AM
  4. Replies: 1
    Last Post: 09-27-2013, 03:53 PM
  5. Navigation Subform issues
    By bsc in forum Programming
    Replies: 1
    Last Post: 11-29-2011, 11:37 AM

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