new data in continuous form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 11 Apr 2006 12:38 GMT

Good morning,

Which event will be triggered whenever a user enters new data in a
continuous form or when they edit/modify an existing entry?

Thank you,

Daniel

Reply to this Message

Allen Browne - 11 Apr 2006 13:04 GMT

The BeforeUpdate event of the *form* fires before the entry is saved, so use
that to validate the entry.

The form's AfterUpdate event fires after a record has been changed, so use
that if you need to respond to a change.

The form's AfterInsert event fires after a new record has been added, so use
that if you need to respond to a new entry.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Good morning,
>
[quoted text clipped - 4 lines]
>
> Daniel

Reply to this Message

Klatuu - 11 Apr 2006 14:54 GMT

My two favorite events are the BeforeNap and AfterNap events. They differ
from the typical Before and After events in that the BeforeNap event cannot
be canceled - not even with error handling. The AfterNap event can be
canceled and can be made recursive with the use of the Time event.

> The BeforeUpdate event of the *form* fires before the entry is saved, so use
> that to validate the entry.
[quoted text clipped - 13 lines]
> >
> > Daniel

Reply to this Message