Setting focus

[icemanmt78]

I have a second form with a label stating that a database is updating. I want this form to appear when i am processing some data into a database.

I am using the following code:

If Pass = "woods" Then
cmdDelete.Enabled = False
cmdEnd.Enabled = False
frmUpdate.Show
frmUpdate.SetFocus
DeleteTables
cmdDelete.Enabled = True
cmdStage1.Enabled = True
cmdStage2.Enabled = False
cmdEnd.Enabled = True
Else

My second form shows on the screen but it is transparant.
I have tried to set focus on this form but to no avail.

Any ideas of how to show the second form when the processes are working without becoming invisible?

[rcallan]

A quick call to DoEvents should refresh the form for you, call it just once after the call to show the form.

[ysa1441]

or you could try form2.refresh