Is there VBA coding to identify in a Form_Open Event that a DoCmd.Open "frmName" is being opened as hidden?

I'm working with an Access database that may be opened in another form and want to know if the Form_Open Event can tell if its being opened as hidden or visible?

In other words, is there VBA coding to identify in a Form_Open Event that a DoCmd.Open "frmName" is being opened as hidden?
LVL 1
stephenlecomptejrAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ragoranConnect With a Mentor Commented:
have you try to test the property me.visible ?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Curiosity overwhelms me.. what is the purpose of opening a form as .Visible = False?  There are very few requirements I've seen where this is needed.
0
 
ragoranCommented:
Personally, When I have a very large form that are used often, instead of closing the form, I hide them.  So when the user click on my menu to reopeon, I simply made them visible again... much faster

(I managed my own collection of "forms" to implement this behavior)

But I can't assume that it is the same for the asker.

0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
That, and if you want to have an event that fires every x time interval, that is best done with a hidden form, even though it hogs resources.

I've seen a lot of badly-designed apps that pass variables back and forth using hidden forms.
0
 
ragoranCommented:
>> I've seen a lot of badly-designed apps that pass variables back and forth using hidden forms <<

Yuck!
0
 
stephenlecomptejrAuthor Commented:
>> I've seen a lot of badly-designed apps that pass variables back and forth using hidden forms <<

I've got a startup form that opens another form - that opens up several bound forms to speed up the access to data.  One of the bound forms happen to have combo box's recordsources adjusted upon opening and refuses to be visible until I used the above code.

If you think this is another badly-designed app - you guessed correctly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.