Run macro on next / previous navigation buttons?

[Guest]

Hi,

I’m trying to get a macro to run from an event in a form. If I set it up to
run on double-click it works just fine. But what I want to do is have the
macro run when I click on the next record or previous record navigation
buttons at the bottom of my form. I can’t find a way to do this on the form
properties. Any suggestions?

 

[John W. Vinson]

Hi,

I’m trying to get a macro to run from an event in a form. If I set it up to
run on double-click it works just fine. But what I want to do is have the
macro run when I click on the next record or previous record navigation
buttons at the bottom of my form. I can’t find a way to do this on the form
properties. Any suggestions?

The form's Current event fires when you move to a different (or new) record.

John W. Vinson [MVP]

 

[fredg]

Hi,

I¢m trying to get a macro to run from an event in a form. If I set it up to
run on double-click it works just fine. But what I want to do is have the
macro run when I click on the next record or previous record navigation
buttons at the bottom of my form. I can¢t find a way to do this on the form
properties. Any suggestions?

Use the Form's Current event.

 

[Guest]

Many thanks guys. I really appreciate the help.