Hide all subforms on Open of main form

[prosfora via AccessMonster.com]

Now that I am able to make multiple subforms visible, one-at-a-time, based on
a selected value of a combo box, is there a way to make all the subforms
hidden when the main form opens? (or even create another object to cover
them until an update is made). As always, example code is welcome.

 

[Graham R Seach]

Subforms are actually controls on the main form. Just set their SourceObject
property = ""

What I often do, however, is to create a blank subform, and make *that* the
default subform. Change the SourceObject property when you want to display
and use the real subform.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia