How can I change a subform, depending on a radio button

[Bob Richardson]

My main form has some radio buttons. When the user clicks a radio button, I
want the SUB to change. I don't want to open a new form...just a new
subform.

For example,

Select Case Frame1.value
case 1
Subform = "Sub1"
case 2
Subform = "Sub2"
case 3
Subform = "Sub3"
end select

DoCmd.OpenForm Subform

but of course this opens a new form, not a subform. Is the only technique
to put three subforms on top of each other on the main form, and then make
the appropriate subforms visible or nor-visible?

 

[david epsom dot com dot au]

case 1
me.MySubformControl.SourceObject = "myFormForSubform"


(david)