What event is for "Next Record"?

[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!!

 

[Dirk Goldgar]

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!!

The form's Current event fires whenever a new record becomes the current
record.

 

[Albert D. Kallal]

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.

 

[Duane Hookom]

Try the On Current event of the form.

 

[Marshall Barton]

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.

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