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.

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


"Jonathan" <(E-Mail Removed)> wrote in message
news:A6112364-C693-4851-94D0-(E-Mail Removed)...
> 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.
>
>

"Jonathan" <(E-Mail Removed)> wrote in message
news:A6112364-C693-4851-94D0-(E-Mail Removed)...
>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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)