Subform recordsource

[kadara]

Hi,

I put on a form an unbounded subform. I would like to set different recordsources to this subform depending the selected option button. Form example:
CASE 1
bound "Query1" to the subform
CASE 2
bound "Query2" to the subform

Please help.
Thanks.

 

[Galaxiom]

From the main form module is a case statement to set the property:

Me!subformcontrolname.Form.RecordSource = "queryname"

 

[gemma-the-husky]

alternatively, if you want to change the actual form (rather than the query)

you have

Me!subformcontrolname.Form.SourceObject = "formname"