Load Subforms via Combobox

[darreno]

I have multiple subforms and would like advise on how to load only one on the main form via a combobox. I searched the forum but can't find any past solutions. Thanks.

 

[ShaneMan]

I have multiple subforms and would like advise on how to load only one on the main form via a combobox. I searched the forum but can't find any past solutions. Thanks.

Hey darreno,

One thought would be, you could put one subform object on your main form and then in the cboBox AfterUpdate event change the SourceObject for the subform according to the choice made in the cboBox.

HTH,
Shane