Navigation Buttons

[chuckster]

I want to put some code on a form that will check the conditions whenever someone changes the focus of the current record to another one.

Can I make code reactive to the navigation buttons or something.

Chuck

 

[R. Hicks]

The On Current event of the form fires when the form intially opens to a record and will also fire each time you navigate to a different record.

HTH
RDH

 

[chuckster]

Cheers but I want it to fire before you leave the current record so that the code can quickly check whatever changes have been made.

Something like the lostfocus or afterupdate event but for the current record on a form rather than a single control.

Any ideas

Chuck

[This message has been edited by chuckster (edited 09-27-2001).]

 

[R. Hicks]

Your original post was not clear to me.

You need to use the Before Update event of the form. This event only fires if you enter a new record or anything is changed in an existing record. This happens before the record is actually saved to the table.

Maybe this will do what you need.

HTH
RDH

 

[chuckster]

You're right my first question was unclear.

Anyway thanks M8 that's the one!

Chuck

[This message has been edited by chuckster (edited 09-27-2001).]