How do I know what 'mode' (add. edit etc) a form is in from VB code?

[Isis]

If I am running code to do some stuff - how do I test what sort of action
is being performed on a form - IE is this a brand new form being filled out
or is it an existing one being edited.

Thanks

 

[tina]

it's not the *form* that is "brand new" or "existing", it's the *record*.
use an If statement in your code to check the form's NewRecord property, as

If Me.NewRecord Then
' do some "new record" stuff
Else
' do some "existing record" stuff
End If

hth