Cascading field

[Roger81]

Hi,

I 've got 2 fields: country and city. After selecting the country(row source from the countries table) I want to be able to select only the cities from that country, in other words, in the row source of the city I use a query like:
SELECT TS_TiposTest.IDCity
FROM TS_TiposTest
WHERE TS_TiposTest.IDCountry= ???CurrentRecord??? How do I select the current record IDCountry value?

I need to do this at data (table) level, doing it at form level doesn't solve the problem.



Thanks!

[rpeare]

assuming the IDCountry is your first combobox

SELECT TS_TiposTest.IDCity
FROM TS_TiposTest
WHERE TS_TiposTest.IDCountry= me.IDCountry

then in the ON EXIT property of your country combobox you have to requrey the contents of the IDCITY combo box

IDCity.requery

[Roger81]

Thanks! Problem solved