I have a set of tables for provinces, their divisions, subdivisions etc and a form where user chooses province, etc. As he does this, the subordinate comboboxes need to change their rowsources and the controlsource value, which normally becomes blank.

What is the best way to accomplish this? I have experimented with filters and with set relations with not very good results.

TIA,

Alex