open query by combo box?

[romanticode]

i have several query and want to open it by combo box & button.

if user select "AA" on combo box an then pres a button, query "11" will be opened.
if user select "AB" on combo box an then pres a button, query "12" will be opened.
etc

how can i make that form?

thanks

 

[ajetrumpet]

Why don't you just write a few Case statements in a Select Case block that will carry out the action you want based on the conditions that you specify?

Like...

OnClick

  Select Case me.comboboxname

    Case "AA"
      Docmd.OpenQuery "11"

    Case "AB"
      Docmd.OpenQuery "22"

Does that work?