On what event can new record code be added ?

[Guest]

I want to perform an action every time the user clicks the add button to add
a new record on a form so I put it within the add button code. The user can
also use the down arrow key to add a new record. Is there an event that
fires when the user uses the down arrow key to move to a new record ? I
checked the form events and could not locate one.

 

[Marshall Barton]

I want to perform an action every time the user clicks the add button to add
a new record on a form so I put it within the add button code. The user can
also use the down arrow key to add a new record. Is there an event that
fires when the user uses the down arrow key to move to a new record ? I
checked the form events and could not locate one.

You can use the form's Current event. To distinguish
between existing and new records, check the form's NewRecord
property.