CAN I OPEN DIFFERENT FORMS FROM 1 COMBO BOX

[zachsiue]

Hi,

I would like to set up a combo box so that when a user selects an item from the box, a form specific to that item will be opened. Is this possible? If so what code would I need to implement this?

i.e.
On a form called Main,
cboExample contains the following entries: ItemA, ItemB, and ItemC.

If ItemA is selected, FormA is opened.
If ItemB is selected, FormB is opened.
If ItemC is selected, FormC is opened.

I have only worked with access for a couple of weeks, so if there is a way to do this please be explicit.

Thank You!!

Zach

 

[dakota81]

Simple - In the properties of the combo-box, make an after_update event and select code builder. In the code, add something like below, only customized to your names:

------------
Select Case [ComboBoxName]
Case "Selection1"
DoCmd.OpenForm "SomeFormName"
Case "Selection2"
DoCmd.OpenForm "AnotherFormName"
Case "Selection3"
...
End Select
------------

 

[zachsiue]

THANK YOU!!!!!
It worked wonderfully!! After finishing that, I came up with another question. Is is possible to open a form using the outcome of two combo boxes? I guess I'm getting greedy, but if its possible it would make life alot easier!!

Thank you so much!!

Zach