Checking for opened form

[John]

Hi

How can I check in code if a form is currently open i.e. running?

Thanks

Regards

 

[Douglas J. Steele]

You can search the Forms collection (only loaded forms are in the
collection), you can look at the IsLoaded property in the AllForms
collection or you can use the acSysCmdGetObjectState action of the SysCmd
method.

 

[Guest]

Sorry, can you tell me how to display data from table to Status Bar Text with
this method?
Thanks!

 

[David PONDA]

Here Igor,

use this code in your global Module :

Sub MsgBar(msg As String) '*** Display message in status bar ***
RetVal = SysCmd(acSysCmdSetStatus, msg)
End Sub

and use this code make a call procedure
MsgBar "Ready"

 

[Guest]

Thanks David, I try to do this but unsuccessfuly...
I make table Descriptions with columns ID (auto num.) and DESC (text).
How to call with code some ID from this Table to display DESC in form status
bar?