FORM ON FORM

[sal21]

I just have a form sow with variuos commbo box.
One of this combobox caal a ADO routine to fill a list view.

This operation take a few secs, approx 2 minutes.

Now during this time i need to show a new form with label "please wait... data retrive"

How to whitout lock the fiiling of listview?

I have make this but freeze entire process...

Code: Select all

Private Sub DATE1_Click()

    On Error GoTo Err_SomeName
    
    ATTENDERE.Show vbModal
    
    Me.Label12.Caption = ""
'ado code..... to fill listview 

Unload ATTENDERE

End sub

[HansV]

You could call the ADO routine from the ATTENDERE form, in its UserForm_Initialize event procedure.
Or do away with ATTENDERE and display a label or text box on the first userform.