>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
There was a discussion on this same topic in tek-tips about a year+ ago. If memory serves, Tamar Granor provided a good sample.
Anyway, you can use either local view or Cursor Adapter here.
If it's not broken, fix it until it is.
My Blog