Combo Box that controls a data entry form

[Alan K via AccessMonster.com]

I have a combo box on the main form. when the user picks an item in the
combo box, i need a data entry form to open on the main form, positioned
underneath the combo box. An then when another item is picked a new form
will open and replace the previous form.

I don't think I can use a subform because the data fields on each form is
different. There a 5 different forms that can be chosen from the combo box.

Does anyone know the best way I can do this?

Thanks,
Alan K

 

[Jeff Boyce]

Alan

A subform control on your main form has a "source". Until it has a source
(i.e., points to the form to use as the subform), it holds nothing.

It seems to me you could use the AfterUpdate event of your combo box to set
the source (i.e., the sub form name) of your subform control.

Or have I missed something?