>>>>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.

I missed the "local" in "local view". I am using Codemine framework but I think it hadles cursor adapters fine. So you'd set up the CA and then requery it? Or does that happen automatically when you requery the combobox?

Could you give some specifics please?

Thanks,

Alex