Caption not updating

[pop79]

I have a main form that has a label that displays a status message to show the status of what the database is doing (like connecting to ODBC tables).

I'm having a problem where I have some code that runs to relink ODBC tables using a DSN-less connection, but before doing this I would like the status label to display a message like "Connecting to data sources..." but unfortunately it appears that Access does not execute code in sequential order. The label does not change, but the connection routine runs, and after the connections have been updated then the label is changed. Is there anyway to make a label act in the way I want it to?

    Case "CONNECT"
      UpdateConnectionStatus
      ConnectToData
      UpdateConnectionStatus

 

[RuralGuy]

Try putting in a DoEvents first to give other Access tasks some cpu time.

 

[pop79]

Thanks heaps, it works great

Edit: but could my code have any flaws? Like waiting forever?

Case "CONNECT"
      ODBCStatus = 3
      UpdateConnectionStatus
      While DoEvents > 0
      Wend
      ConnectToData
      UpdateConnectionStatus

 

[ecawilkinson]

Pop79,

this would work as well:

Case "CONNECT"
      ODBCStatus = 3
      UpdateConnectionStatus
      DoEvents
      ConnectToData
      UpdateConnectionStatus

HTH,
Chris