Linking a form to a combo box

[zachsiue]

Hi,

I have created a form that is built off of several different tables and subforms. In order to "hide" some of the complexity of the form, I was wondering if it were possible to have a form/subform start up after a selection has been made from a combo box. Is this possible? If so, how could this be done? I don't have much experience with access, so as much detail as you can give would be greatly appreciated.

Thank You in Advance,
Zach

 

[lheyde]

You need to attach a Macro or Code to the "on change" field of the combo box's property. If you are a beginner a macro would be easier. click the build button (...) next to the On change box. Select create macro, name it, for the action select "open form" then chose the form on the bottom of the screen that you want it to open. Hope this helps.