Is it loaded as subform?

  • Thread starter Thread starter Michael S. Montoya
  • Start date Start date
M

Michael S. Montoya

I have a form that is always loaded. It is called "frmDashboard"
On this form I have a "SubHolder" which holds a subform. The source of the
subform changes depending on the menu option is selected. In other words,
if the user selects "Companies" the "Companies" form is loaded into the
subform. If the user selects "Contacts" the "Contacts" form is loaded into
the subform. Only one open at a time.

Now, if Contacts is selected as the subform, there is a combobox that, when
double-clicked" will open the "Companies" form as a popup. frmDashboard
IsLoaded, the subform is "Contacts" and "Companies" IsLoaded.

I need to reference a control on the "Companies" form from another form,
however, sometimes it can be
Forms!frmDashboard!frmCompanies.Form!cmCompanyID and sometimes it can be
Forms!frmCompanies!cmCompanyID.

I would rather not use OnError or a bunch of "IsLoaded" if I don't need to
as I plan on using this for other forms as well. What is a way I can refer
to "cmCompanyID" "generically" or requery "cmCompanyID"
 
Unfortunately, there's no way to refer to a control "generically"

I think you're going to have to go with OnError or a bunch of "IsLoaded".
 
Just reread the subject of your post.

Subforms do not show up as being loaded: they're not part of the Forms
collection.
 
Back
Top