In the event of the form load, I put a lot of code as verifying the
queries, if not there I create them, initialized the controls, etc.  but
with all of that code, it is very slow to load forms.

Where could I put that code and have my forms load rapidly?

I don't want to keep the form only hide.  I want to unload and load form
when necessary.

--
Nathalie Turgeon

Simply place a Me.Show in the form Load event at the point you want the form
to be shown. Also don't forget to set the mousepointer to an hourglass to
let the user know the form is not yet ready