>>>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.
>
>Thanks Naomi. The tables are all dbfs.
>
>Alex
You're saying you don't want to use either local view or CursorAdapter, correct? You can use cursors and re-select (unbind combo and re-bind it back), but I think two other options sound better.
If it's not broken, fix it until it is.
My Blog