events for record navigator

[mcnews]

are there no events associated with the record navigator?
such as previous_click, next_click, first_click, last_click,
newrec_click or something?

 

[scubadiver]

Certainly.

create a button in the wizard and select 'record navigation'.

 

[scubadiver]

vba:

DoCmd.GoToRecord

 

[mcnews]

Certainly.

create a button in the wizard and select 'record navigation'.

i'm talking about the MS Access form record Navigation Buttons - not a
button that i draw.

 

[mcnews]

The form's Current event fires any time the form goes to a different record.
The navigation buttons move the form to a different record so the form's
Current event fires when you click any of the navigation buttons.

Steve

so you're saying the answer to my question is no?

 

[mcnews]

Strictly speaking, there are no properties associated with the navigtion
button's where you can assign code to an event. However you can get code to
execute when you click any of the navigation buttons by putting the code in
the form's Current event.

Steve

i am trying to not use the on current event.
something is going on in my app this is causing the on current event
on my subform to fire more than 3 times every time i move the main
form to a new record.
i have spent several hours trying to trace what might be causing this,
but have failed so far.

so i know all about the on current event - except how to stop it.