Userform activate event question
try unloading the form rather than hiding it.
Is your code in the Activate Event or the Initialize event. The latter only
fires on creation of the form, not unhiding it.
--
Regards,
Tom Ogilvy
dan wrote in message
...
I have a form with several listboxes buttons etc that is called up via a
toolbar button which then calls a macro that does a frmMyform.show.
I have several initializing tasks which must be done that I have put in
the form activation event. on OK or quit out of my form I do a
frmMyform.hide.
All works well the first time around.
The next time however the activation events do not get fired (when I again
do a frmMyform.show).
Am I opening and closing using the common practice? If I move my
initializing events to the macro that calls the form in the first place it
fails because the form object has not been created.
Thanks in advance ...
|