Checking what mode form is in using code?

[skulmat]

Is there a lineo f code that i can put in that will check the mode that the
form is currently opend in(edit, add, ...), so that i can incorperate it
into a if...else statement?

tahknx

 

[Jeff Conrad]

Something like so?

Private Sub Form_Open(Cancel As Integer)
Select Case Me.Form.DataEntry
Case True
' Do something here
Case False
' Do something else here
Case Else
' Nothing, ignore
End Select
End Sub

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: