Open A Sub-Form Using A Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick hfrupn - 21 Oct 2007 09:16 GMT

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

Reply to this Message

Ofer Cohen - 22 Oct 2007 10:43 GMT

To change the sub form try

Me.[SubFormControlName].SourceObject = "SubFormName"

Using the AfterUpdate event of the ComboBox

Signature

Good Luck
BS"D

> 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.
[quoted text clipped - 3 lines]
> Regards
> Nick

Reply to this Message