Can I open a form based on the results of two cbo's

[zachsiue]

Hi,

I have created a main form in which the user selects an item from cboONE and it determines the items that are displayed in cboTWO. Depending on the selection in cboTWO, a unique form will open.

My problem has occured because, some of the selections from cboONE produce identical seclections for cboTWO. I was wondering if it were possible to write code that would cause a form to open based on the results of BOTH cboONE and cboTWO. I am a new access user and have never used VBA before, so as much detail and help as you could give would be greatly appreciated.

Thanks a ton in advance!!!

Zach

 

[zachsiue]

Is this not possible to do using vba?

 

[PWise]

this can be done but i will need more info as to what is in combo1 and in combo2 and what form you want to open