Opening a form that may already be open

S

Sarah

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?
 
B

biganthony via AccessMonster.com

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
 
Top