Hey all,

I'm having some trouble (which is frustrating b/c it seems so simple) of trying to get a form which says "Please wait" or something like that display while a rather intensive method is running (anywhere from 5-15 secs long).

My code is:

Code:
Private Sub cmdCreateGraphs_Click()
frmMain.Hide
frmLoading.Show
frmGraph.FindUniqueField
frmGraph.Show
frmLoading.Hide
End Sub
With this code, the frmLoading is never hidden. It just keeps staying up there, but if you close it (much after the method has finished running), frmGraph appears with the method complete. I've tried moving around frmLoading.hide all around these 5 lines of code with no success. Also if you document out frmLoading.show/hide, everything works, save an awkward 5-10 secs where a user might think my program crashed.

Any ideas? Thanks