One main form but showing separate parts when a user presses a button

[Averian]

Afternoon all,



As the title suggests i have one main form which has high level information, lets say that is level 1, when the user needs to, they press a button which is level 2, and such from level 2 if they need more they go to level 3 via a button and finally from level 3 goto level 4 all while showing all information up the level they have selected.

Each level has a pricing matrix attached and the higher the level they go the more pricing options they have to play with.

Any ideas how i do this, i have a feeling its sub forms but i am unsure how to hide them or show them via clicking a button.

Thanks for your help in advance!

[orange]

I suggest you show us your tables and relationships as a jpg or png file.
It might also help you and readers if you gave us an example to put your data into context.
Levels, buttons and price is a little abstract without seeing some design.

Good luck.

[ranman256]

subforms? But instead of button, put a combo box.]

data in combo box:
CAPTION, FRM
-------------------
Pricing, frmSubPricing
Sales, frmSubSales
etc

user sees col 1 (caption), col 2 (the subform) is hidden
then when user picks the item, the subform displays that data from col 2.

private cboBox_afterupdate()
    me.subform.SourceObject = cboBox
end sub