Pause code? 1

[gnt]

I'm fairly new to vba, so this may be a rather elementary question. I am using vba to run queries in another access database, but I want to change the visibility of controls in the current database first. My code is as follows:
-------------------------
If optfrmCompany.Value = 1 Then
optfrmCompany.Visible = False
lblWait.Visible = True
Dim db As Database
Dim qyDel As QueryDef
Dim qyIns As QueryDef
Dim qyUpd As QueryDef
Set db = DBEngine(0).OpenDatabase....
--------------------------
The problem is, Access switches databases before it hides 'optfrmCompany' and displays 'lblWait'. Is there any way to pause while it finishes these commands before defining the new database?
Thanks-

 

[BrainB]

Have a look at 'DoEvents' and 'Wait' VBA commands. Regards
BrianB
** Let us know if you get something that works !
================================

 

[Junior1544]

I personaly don't like do events... it does more then one would think...

It sounds like these controls you reference are on a form...

try
me.repaint
in this code... it repaint's the screan... i think that's what you want...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[gnt]

Repaint works beautifully!
Thanks so much!

 

[Junior1544]

no problem... i prafer not to use do events because it checks the thread que for the entire computer and realy slows down a program...

Don't forget to give star's to people that provide helpfull information.

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.