two subforms controlled by a combo box

[emitecaps]

Hi,

I'm v.new to Access so do excuse my ignorance.
I have a form with a combo-box with the following values:
Planes, Trains, Cars
When Planes is selected I'ld like planes_subform to appear.
When Trains is selected I'ld like Other_subform to appear
Once the data has been entered in the subform the user would continue back to the main form.
I'ld like the subforms to remain hidden until needed, if possible so as not to confuse users.

Any help would be greatly appreciated

thanks

Barry

 

[PHV]

Why not using a TabControl with 3 Pages ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244