Hi,

Is it possible to use cascading comboboxes in datasheet view?

Explanation:
I have 3 tables: Person, Country, City.
I could set the Person.CountryID and Person.CityID fields to be displayed as lookup comboboxes by providing the appropriate SQL query.
My problem is that after selecting a country in datasheet view, only the cities within that country should be populated within the second combo box?

Is it possible?

Thanks.

The datasheet section would be a subform. The combos would have their row source set using vba in the On Current event of the subform.

If you remove the borders and record selectors from the subform object it will look like part of the main form.