Determine the forms datamode

[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.

 

[Jeff Conrad]

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

 

[Guest]

Cheers Jeff. I thought it would be something simple.

 

[Jeff Conrad]

You're welcome, glad to help.