I have created a form that have a treevie control. This treeviw control is
populated with information coming from a recordset.
In the code view of the form I have a sub (Private Sub
userform_initialize()) that call a couple of subs (a sub that populate the
treeview).
My problem is that I would like to have the form diplayed on the screen
while the sub populate the treevview. The problem is that only when the sub
userform_iunitialize is finished the Form appaers.
I have in the module a sub (sub form_load()) that have the following line
userform1.show. When I call this sub from userform_initialize, the form is
displayed but the program stops (like it is in Pause)

Any hint woiuld be welcome. In fact I want to display the form while is
populating because I have a progressbar that I want to show while my program
is parsing my database (using the PercentPosiion property of my recordset)

You could fire the loading code from within another macro triggered by
OnTime within the userform initialize. Something like

Private Sub UserForm_Initialize()
Application.OnTime Now + TimeSerial(0, 0, 1), "loadForm"
End Sub

The loadForm macro should be in a standard code module, and should run the
loading subs of yours.

--
HTH

Bob Phillips

"stabilo" wrote in message
...
I have created a form that have a treevie control. This treeviw control is
populated with information coming from a recordset.
In the code view of the form I have a sub (Private Sub
userform_initialize()) that call a couple of subs (a sub that populate the
treeview).
My problem is that I would like to have the form diplayed on the screen
while the sub populate the treevview. The problem is that only when the
sub
userform_iunitialize is finished the Form appaers.
I have in the module a sub (sub form_load()) that have the following line
userform1.show. When I call this sub from userform_initialize, the form
is
displayed but the program stops (like it is in Pause)

Any hint woiuld be welcome. In fact I want to display the form while is
populating because I have a progressbar that I want to show while my
program
is parsing my database (using the PercentPosiion property of my recordset)