Dirty not picking up new record

[Jonathan]

I have an Access 2003 database where a user starts a new record. I have code
on the form that checks to see if a new record has been started in the close
event:-

If me.dirty then
ValidateRecord
end if

Unfortunatelty the code isn't picking up that a new record has been created
when the user goes File|Exit, which leaves blank records in the database.

 

[Alex Dybenko]

Hi,
Try to use form's BeforeUpdate event to validate record + cancel it if not,
and then use unload event to save record and check if it still dirty

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Dirk Goldgar]

I have an Access 2003 database where a user starts a new record. I have
code
on the form that checks to see if a new record has been started in the
close
event:-

If me.dirty then
ValidateRecord
end if

Unfortunatelty the code isn't picking up that a new record has been
created
when the user goes File|Exit, which leaves blank records in the database.

In the Close event? By the time the form's Close event fires, the record
has already been saved. Validation of a record should take place in the
form's BeforeUpdate event.