Changing the Record Source for a subform

[JC10001]

Can anyone tell me how I could get a subform to change its record source by changing an option button on the master form?

I've done searches on the net and I'm shocked that I can't find this. It seems like it would be a common thing to do.

 

[dcx693]

The code to change a subform recordsource is of the form:
Me.subformName.Form.RecordSource=SQL string or queryname

You can place the code into the After Update event of the option group.

 

[JC10001]

Thank you.