Is a form open?

  • Thread starter Thread starter Stewart
  • Start date Start date
S

Stewart

Is there a simple way of checking to see of a certain frmName is
loaded/open?

When I open a required settings form within a main form (when a required
setting field is empty), my settings form ends up behind the main form.
I'd like to bring the settings form to front & set control focus.
 
Tried this, but doesn't bring the form to front:

Private Sub Form_Current()
If CurrentProject.AllForms("frmComPort").IsLoaded = True Then
Forms!frmComPort!Combo3.SetFocus
End If
End Sub
 

Is your main form set as a Popup or Dialog form? If so, you may have some issues when trying to open other Popup forms.

If your main form isn't a Popup, try opening your settings form as a Popup (you can change this in the form's Properties
dialog in design view).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Scott said:
Is your main form set as a Popup or Dialog form? If so, you may have some issues when trying to open other Popup forms.

If your main form isn't a Popup, try opening your settings form as a Popup (you can change this in the form's Properties
dialog in design view).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Click to expand...

I found the solution:
DoCmd.OpenForm "frmMyForm", , , , , acDialog
 
Back
Top