The change event of the multipage fires when pages are changed. You can use
this event to ensure the data is updated.

--
Regards,
Tom Ogilvy

"Andy" wrote in message
...
I have a VBA form with a MulitPage control that reads
from/Submits to an excel sheet.

Each control on the form calls a submit procedure that
loads the data into correct place in the database (using a
the cells property). This procdeure is called from the
After_Update event of the control

My only problem is that if you enter data in the control
and change pages on the multipage without tabbing,
After_Update doesn't fire and the data doesn't get
submitted.

Anyone know how to force the After_Update when selecting a
new page on the multipage? This is driving me (and my
users) nuts!!

Andy