Problem with closing a form 1

[MikeCt]

I've written a procedure where one form opens another form
using " frm_InventorySearch.Show vbModal "
This second form collects user inputs then send back this data to the original form which performs a search to find
the correct record.
The correct file is located and the outcome is correct but the screen freezes while unloading.
The screen remains frozen till the search in the original form is completed. How can I force the first screen to unload completely before the search begins in the original form?
Were talking seconds here but the look is very unprofessional.

Thanks
Mike

 

[Andrzejek]

Strategically placed [tt]DoEvents[/tt] would fix the problem, but you would have to show us your code.

Have fun.

---- Andy

 

[strongm]

DoEvents is the invention of the devil, and best avoided if possible ...

 

[Andrzejek]

OK, I'll be good, I'll be good

I am sure we can avoid DoEvents and do it with proper order of unloading, activating, and refreshing the forms). As soon as we can have a pick at the code...

Have fun.

---- Andy

 

[vb5prgrmr]

So basically...

(From Form1)
Form2.Show vbModal, Me

(From Form2 when time to unload)
Me.Hide
Form1.MyPublicSub InformationToPass
Unload Me

Should solve your problems without the use of doevents...



Good Luck