Form & EditMode?

[MSJohn]

I have an Access form with a query as the record source.
I have a TextBox BeforeUpdate event to test to see if
the record is an existing record or a new record.

Attempting to use EditMode:
val= Me.RecordSet.EditMode
if (val = dbRecordNew) then
str = "new"
else
str = "not new"
end if

When in the Form, I create a new record via the ">*" Navigation
button, EditMode always comes back as 0 (dbEditNone).

Am I not understanding this correctly? Is there another way to
test for a new record?

TIA

 

[Guest]

If Me.NewRecord Then
'It is A New Record
Else
'It is Not
End If

 

[MSJohn]

Ah! Didn't see that property in the help...
Thanks!