[Solved] Execute Macro when Moving Between Records in a form

[Ant]

I have written a oOOBasic macro that disables some form fields when a field has a particular value.
I can execute the macro when the trigger field is changed, but I need to execute it when moving between records, as the trigger field value varies between records.

Is there a way to execute macros other than directly from a form field?

[QuazzieEvil]

There are various form events (look at the events tab of the form's properties dialog). For what you need you can use the Before/After Record Change events.

[Ant]

Thanks, I finally found where I could access the form properties.

But which event occurs when you move between records? I've tried all the options and none seem to work.
When loading works when you first bring the form up, but not when you change records.
Record action (what is that?) doesn't work, Record change is no good as I want to prevent a record change.
Fill parameters (whatever that mans) doesn't work.

surely oOOBase has a way of triggering a macro when a record changes, I can think of a million uses for such functionality.

[Ant]

Through trial and error I have found the solution:

Use After Record Change event.

For others, to get to forms properties look for a toolbar icon (left side near top on my screen) that looks like a form with slider bar on top of it.