Open A Sub-Form Using A Combo Box

[Guest]

I have a main form, frmEmployee, to record employee detail, one of which is a
combo box, Position. I also have a sub-form for each position.
Is there any way of changing the sub-form in the main form to match the
position selected?

Regards
Nick

 

[Guest]

To change the sub form try

Me.[SubFormControlName].SourceObject = "SubFormName"

Using the AfterUpdate event of the ComboBox