Userform activate event question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ...
 
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 said:
I have a form with several listboxes buttons etc that is called up via a
Click to expand...
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
Click to expand...
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
Click to expand...
initializing events to the macro that calls the form in the first place it
fails because the form object has not been created.
 
Back
Top