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

  • Thread starter Thread starter Bob Richardson
  • Start date Start date
B

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?
 
Back
Top