What event is for "Next Record"?

  • Thread starter Thread starter michaaal
  • Start date Start date
M

michaaal

What event do I use if I want to run msgbox("hello") when the user goes to a
different record (either the next one or any other one).

I thought it was Form Load, but that didn't seem to work.

I use Access 2003.

Help! Thanks!!
 
michaaal said:
What event do I use if I want to run msgbox("hello") when the user
goes to a different record (either the next one or any other one).

I thought it was Form Load, but that didn't seem to work.

I use Access 2003.

Help! Thanks!!
Click to expand...

The form's Current event fires whenever a new record becomes the current
record.
 
The event likely you are looking for is on-current.

The after update event is also useful, as it fires if the user modified the
record, and then moves, or closes the form. Often, we only need to check, or
do something if the record was actually changed..so the before update, and
the after update are most useful.
 
michaaal said:
What event do I use if I want to run msgbox("hello") when the user goes to a
different record (either the next one or any other one).

I thought it was Form Load, but that didn't seem to work.

I use Access 2003.
Click to expand...

The Form's Current event fires when a different record
becomes the current record.
 
Back
Top