Multipage shortcircuits regular action

[Fryer Tuck]

I have a form that has several text boxes and several pages of a multipage. The exit action from a text box runs a routine to check the entry for correctness, and save it to the spreadsheet. This works fine going from one text box to another on a page; but if I make a change in a text box and go directly to another page of the multipage, the exit program is not run until I re-enter that page.

Is there a way to capture the exit of one page, or in some way assure that ALL changes get recorded on the spreadsheet?

 

[Ivan F Moala]

On 2002-05-09 23:20, Fryer Tuck wrote:
I have a form that has several text boxes and several pages of a multipage. The exit action from a text box runs a routine to check the entry for correctness, and save it to the spreadsheet. This works fine going from one text box to another on a page; but if I make a change in a text box and go directly to another page of the multipage, the exit program is not run until I re-enter that page.

Is there a way to capture the exit of one page, or in some way assure that ALL changes get recorded on the spreadsheet?

Why not try updating via the
Private Sub MultiPage1_Change() event ??