>>
>>Firstly, time to open table(s) is negligible, i.e. you may keep all childs opened. In regard to grid: you should make a choice:
>>1. You will override grid recordsource. Here, it's reasonable to base grid on read-only cursor and reset grid settings (recordsource and column.controlsources) after each Select Into Cursor (from combo.interactivechange event).
>>2. You will not override grid recordsource. Here, you may have 'universal' read-write cursor which will be ZAPped and re-populated after each new combo selection.
>
>I gather what you are telling me (in 1.) is that when I change the RecordSource the grid becomes read only? I do not understand why this would be required.
I just meant that Select-SQL creates read-only cursor by definition. Do you want to edit directly in grid?
Edward Pikman
Independent Consultant