Open A Sub-Form Using A Combo Box

N

Nick hfrupn

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
 
O

Ofer Cohen

To change the sub form try

Me.[SubFormControlName].SourceObject = "SubFormName"

Using the AfterUpdate event of the ComboBox
 
Top