Trigger a function when cycling records

[Teleinternnor]

hello i wish to trigger some VBA code when the user jumps from the present record to some other record on the form. there is the On Current event but that only applies to the record you are jumping to. i wish to process the information on the present record if u choose to jump to some other. BTW my form my form only shows one record at a time.
Please help me out here.

 

[ColinEssex]

If you want an event to occur on the current record when the user goes to another record only, put the code in the OnClick of the button that opens the search screen or whatever button you use to move to the next. Make sure it runs first.

Col

 

[ghudson]

Does this only need to happen when the record has been modified? If so, use the forms BeforUpdate event. If not, then you are going to slow down the process of the user who needs to scroll through the records with what you are trying to do.

 

[Teleinternnor]

thnx for the reply ppl.
i can not use the beforeupdate event because i have some option groups which dont have any table info as their direct control source but the selection made is used to enter some data into the table. the problem is that changing the option group status doesnt set the dirty flag which in turn calls the beforeupdate event. Maybe there is some way to set the dirty flag on the onclick event of the option group??? Do let me know.
ColinEssex yeah had the same idea as u but i am using the record navigation bar that comes with the access form as default so it doesnt appear in the form design mode. Any suggestions as to how i can code behind this navigation bar.