Checking when "leaving" current record

  • Thread starter Thread starter Atlas
  • Start date Start date
A

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.
 
Atlas

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

Forms have both a BeforeUpdate and an AfterUpdate event you could add code
to.
 
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.
 
Cheryl Fischer said:
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.
Click to expand...

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"
 
Atlas said:
I need to trap when users moves from the current (if modified) record.
Click to expand...

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