Using a combo box to populate a subform

[jcfraun]

My database contains a form (Form1) with one combo box (Combo0) and a subform.

The combo box datasource is a table with two fields: Criteria, CriteriaForm.
CriteriaForm is the name of the form that I would like to have populate the subform on the form.

So, restating, when the user selects a value in the combo box, I would like for the subform to be populated by the form named in the bound column of the combo box.

How do I do this?

Thanks,
Caryn

 

[dhookom]

I would use the after update event of the combo box to change the SourceObject of the subform control to the selected form from the combo box.

Duane
Hook'D on Access
MS Access MVP

 

[jcfraun]

Using VBA? Can you give me an example of what the code would look like?

 

[jcfraun]

Got it! Thanks!