Determine the forms datamode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I determine the current datamode of a form when it is opening. I want
to display a different caption depending on whether the mode is acFormAdd or
acFormEdit.

Will use it in a select statement

Select Case Mode
Case acFormAdd
Me.Caption = "Add New Customer"
Case acFormEdit
Me.Caption = "Customer Details"
End Select

Cheers, Wayne.
 
Private Sub Form_Open(Cancel As Integer)
Select Case Me.Form.DataEntry
Case True
Me.Form.Caption = "Add New Customer"
Case False
Me.Form.Caption = "Customer Details"
Case Else
' Nothing
End Select
End Sub
 
Back
Top