Data bound VBA forms
Thanks Tom,
Andy
-----Original Message-----
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
.
|