How to open Access 2010 Navigation Form in acAddMode

[KurtBergman]

The Access 2010 Navigation form has very little documentation. One issue is moving to a different Tab (subform) in data AddMode.
The assumed method is

DoCmd.BrowseTo acBrowseToForm,[Form Name],[Path To Subform],,,,acFormAdd

Unfortunately the target form will still open in EditMode

One workaround is to declare a public variable the suborm can use during the On_Load event.

First: create a new module 'modForms'

add the following Type and Enum

Public Enum FormDataMode
   EditMode = 1
   AddMode = 2
End Enum
 
Public Type Q_Forms
   frmMode As FormDataMode
End Type
 
Public QForms As Q_Forms

Add a Private procedure to the Navigation subform calling the subform to be opened in AddMode:

Private Sub OpenSubForm(DataMode As FormDataMode)
   On Error GoTo ErrorHandler
 
   QForms.frmMode = DataMode
 
   DoCmd.BrowseTo acBrowseToForm, "[MySubForm]"
 
End Sub

Add a command button, DoubleClick event etc. to the NavigationForm calling subform and pass the DataMode as the variable:

 
OpenMySubform AddMode

On the On_Load of the called subform add:

Private Sub Form_Load()
   Select Case QForms.frmMode
      Case AddMode
         Me.DataEntry = True
      Case EditMode
         Me.DataEntry = False
      End Select
End Sub

And there you have it.

[twinnyfo]

Kurt,

Thanks for your advice. I've seen quite a few posts about some of the problems with Access Navigation Forms. Hopefully, this post will guide some other users to success.