I have an application that loads in quite a list of data from a SQL server into a combo box. it takes a little bit of time to do this. im trying to call up a splash screen during the process so that the user is patient. my application is for a print driver so it needs to respond immediatly.

what i tried to do is at the beginning of the form_Load show a form that is my splash screen, and then call the function that fills in the combo box, but the splash screen dosnt show till the db functions are finished.

any tips?

thanks
/daniel

The easy way is to call DoEvents after you show the splash screen. BTW the splash screen should not be loaded in the load event of the main form, but in the Sub Main method. Because I hate DoEvents, another possibility is to put the code in the first Activate or Resize event of the splash screen. Or, because that is ugly, in a event fired by the splash screen. Using ADO, my preference is to call the ado methods with the FetchAsyncNoBlocking property.

Marco

Daniel, I'm tying to do exactly the same thing. I tried the following without any luck.

Sub Main() 'In a module
 frmSplashScreen.Show
End Sub

Sub UserFrom_Activate () ' In Splash Screen form
 Load frmMain
 Unload frmSplashScreen
 frmMain.Show
End Sub

Did you come right, and could you offer any advice?
Richard