Opening a form that may already be open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all

I could use a few clues here. In places of my project, I click on a button
to Open another form. But, there are times when that form may already be
open but just not visible. How do I do...

1) Open the form if it is not open, but make is visible if it is open?
2) Is this really necessary? Does Access already have this functionality
built in?
 
Hi,

Can't you use the IsLoaded property?

eg If CurrentProject.AllForms("FormName").IsLoaded = true then
FormName.visible=true
else
docmd.OpenForm,acNormal "FormName"
endif

Would that help?

Anthony
 
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

Executing a hidden query 1
Opening the form 1
ByPass key ms access 2016 0
Opening a Form and Changing It/Running a Procedure 3
Calling Access 'form' from other applications 0
Opening a form already open 1
Access Open Form with WhereCondition 6
Open Specific Worksheet Using Button Form Control in Excel 0

Back
Top