Select between 2 queries in a combobox

[smba]

Hello,



I have a form with some combobox, and I would like to change the values of one of them (combobox2) by selecting between 2 diferent queries in the "Row Source" depending on the value of other combobox (combobox1).

Is it that possible?

Regards

[CJ_London]

sounds like you are talking about 'cascading comboboxes'. There are a number of solutions - try googling 'cascading comboboxes' to find out more. A common solution is to have the rowsource of your second combo to be something like this

SELECT *
FROM myTable
WHERE afield=[combobox1]

in the rowsource (as code, not as a query)

and in the combobox1 afterupdate event put

combobox2.requery

if it is not just a matter of changing the criteria then in the combobox1 afterupdate event put something like

select case combobox1
    case 1
        combobox2.rowsource="SELECT * FROM table1"
    case 2
        combobox2.rowsource="SELECT * FROM table2"
end select