D
David Mueller
Hi All,
My form wizard is adding BeforeUpdate and AfterUpdate events for all the
controls on the form it creates.
It took 70 seconds to add 42 events (21 controls) on two different subforms.
The code loops through the subform's collection of controls, fetches the
event name & VBA code from a table, creates the event, next control . . .
Everthing else (form opens, form saves, queries, ...) runs reasonably fast.
Any suggestions? Thanks,
David
My form wizard is adding BeforeUpdate and AfterUpdate events for all the
controls on the form it creates.
It took 70 seconds to add 42 events (21 controls) on two different subforms.
The code loops through the subform's collection of controls, fetches the
event name & VBA code from a table, creates the event, next control . . .
Everthing else (form opens, form saves, queries, ...) runs reasonably fast.
Any suggestions? Thanks,
David