Switching between subforms based on a checkbox in the mainform

[jom1918]

I am a novice with MS Access, so I need all the help I can get.

I have a main form with several checkboxes and I would like the subform to change based upon which checkbox the user checks.

I have 3 different subforms and I would like them only to be displayed once the user has checked the corresponding box in the mainform and also wouldlike the subform to change when/if the user changes their selection in the mainform.

Can anyone get me started on the code I need to use?

 

[pbaldy]

Me.SubformControlName.SourceObject = "FormName"