Checking when "leaving" current record

[Atlas]

Due to my "rookieness" I can't find an easy way to manage event when
"leaving" a record on a CF or a DS.

What is the easiest way to do so?

Thanks

Atlas -
Rookie on the run, powered by Access's "Smart by design" event model.

 

[Jeff Boyce]

Atlas

What's a "CF"? What's a "DS"?

Forms have both a BeforeUpdate and an AfterUpdate event you could add code
to.

 

[Cheryl Fischer]

CF = continuous form?
DS = datasheet ?

AFAIK, there is no event that occurs when you leave a record but before you
enter the next record. The closest event to what you want is probably the
On Current event. But, maybe not... If you'll provide some more
information about what it is that you want to happen, perhaps we can suggest
something.

 

[Atlas]

CF = continuous form?
DS = datasheet ?
Yep!

AFAIK, there is no event that occurs when you leave a record but before you
enter the next record. The closest event to what you want is probably the
On Current event. But, maybe not... If you'll provide some more
information about what it is that you want to happen, perhaps we can suggest
something.

I need to trap when users moves from the current (if modified) record.

Unfortunatelly sometimes it makes sense to enforce checking only when all
the fields are filled in the record, and not simply check the afterupdate of
every control........

If the form's afterupdate traps it it would be perfect...........

BTW I use the "On current" regularly, but it works when you "arrive" on the
record not when you "depart"

 

[Rick Brandt]

I need to trap when users moves from the current (if modified) record.

If you are only concerned with running code before leaving an "edited"
record then use the BeforeUpdate event of the Form. It will fire before
leaving the record and if cancelled the form will stay on that record.