Combo box option determines the subform on a form?

[Morpheus_UK]

Does anyone know how to do this. So you have a combo box on your main form with 4 options, depending on which option you select a related subform (1 out of the 4 pre-made forms) will appear on the main form.

Any advice on this would be great

 

[MStef]

Hello Morpheus!
Why complicate? Look at "DemoTabA97.mdb".
(MStef alias Štef)

 

[Morpheus_UK]

Thanks for the reply MStef, but I want one Subform only. You see each suform has a different set of questions. If you select Member from this combo box, I want a member subform displayed. If you select Non-Member, a Non-Member subform displays. The related subfroms have different questions thats why I want only one displayed as opposed to a multi-tab thing like you suggested. I don't want a Member being able to fill out another set of questions, So thats why I need something different to the multi-tab.

The reason why I'm not doing seperate forms altogether is because most information kept in the profile is constant, apart from which category a profile belongs to, hence the need for the subform.