Form & EditMode?

  • Thread starter Thread starter MSJohn
  • Start date Start date
M

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
 
Back
Top