change subform completely based on combo box

[benjammin]

Hi, I have an unbound form that has a few combo boxes that eventually drill you down to one choice (which calibration records do you want to see? Water level? Conductivity? DO? Etc...).

I have a subform based on a query but i have different queries for each calibration. Master/Child fields will remain the same but the actual query and subform used will be different. How can I change the subform on the fly like that based off of a combo selection?

[pbaldy]

Change the SourceObject property of the subform control to the appropriate form name.

[benjammin]

Thanks, would there be a way to change the query of the subform so I don't have to create a slew of subforms?

[pbaldy]

Ah, you said "the actual query and subform used will be different" That said, you can certainly change the RecordSource property of the subform.