Open Form

  • Thread starter Thread starter JimP
  • Start date Start date
Jim,

Try using this function.

Public Function IsLoaded(sFormName As String) As Boolean
IsLoaded = ((SysCmd(acSysCmdGetObjectState, acForm, sFormName) <> 0) _
AND (Forms(sFormName).CurrentView <> 0))
End Function

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forms Syntax 2
How to close a Form object? 5
Form.Recordset.RecordCount in Access2007 6
Open a second instance of a form 7
Form_Delete event can't fire requery in other form 1
dropdown to filter records 1
docmd.openform 1
How to access an instance of a form in forms collection 1

Back
Top