Conditional Subform

[cmbirk]

I have a main blank form that contains 2 subforms. One of the subforms I want to stay constant in the main form. The other, however, I want to be controlled by a combo box. If the user selects one of three options, I want to draw in a different subform into the main form. The example I am doing this for is three divisions in a company. If one of the divisions is selected in the combo box, I want that corresponding subform to replace the current subform. If anyone knows how to do this, it would be a lot of help.

Thanks

[NeoPa]

It depends to a certain extent on how different the various subforms are. In some cases it's better to use a single subform, and change the items that are different between them. Otherwise, you could include all of them, and simply make the ones that are not required invisible.