What Form Event is fired when Navigation button used

[djj55]

Hello, in Access 2002 I want an event to fire before the record changes when a navigation button is clicked.

I need to check (and save) some data before the record changes. Currently if I save it, it is saved on the wrong record. - The save goes to a related table and is being saved related to the new record.

Thank you,
djj

 

[pbaldy]

Try the Before Update event of the form. It won't fire if the user hasn't changed anything though. I would have offered the Current event, but I think that will show the new data, not the old.

Paul
MS Access MVP 2007/2008

 

[djj55]

Thank you for the reply. Do you know why the Before Update event would not fire even if an unbound text box has been edited. The Current event is associated with the new record. The problem comes if the user does not save the text. I wanted it to auto save but the users complained.

 

[pbaldy]

I'd say it was because the data underlying the form hasn't changed, since the control isn't bound to it. The update event of the textbox would fire, but not the form's.

Paul
MS Access MVP 2007/2008

 

[djj55]

Thank you.

 

[JoeAtWork]

An alternative is to create your own navigation buttons, then you will be able to do whatever you need in the click event of your button.

 

[djj55]

Ah yes, Microsoft "helping" out again.

Thank you for your post. The button idea is good but the user will need retrained. "Where is my button?"

Thanks again,
djj

 

[ZmrAbdulla]

This is a related reading on this..

http://www.allenbrowne.com/bug-01.html

________________________________________________________
Zameer Abdulla
Help to find Missing people