Userform activate event question

[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 ...

 

[Tom Ogilvy]

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

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.