VBA code to change a child form

[Courtman]

I have a form with a child-form which displays the results of a query. On the main form are three radio buttons which select different queries in the child form.

I'd like to use a VB code to change from one query to the next, depending on which radio button is pressed. How would I best do this please?

 

[Meltdown]

..see demo

 

[Courtman]

Thanks for the sample code Meltdown, I had something similar already but its refined it nicely! And saved me on two subforms! Marvellous, thanks once again.