>>>>In order to avoid "cannot access selected table" error messages, I read that it's best to add an array property to each ComboBox and set it's rowsourcetype to array, is this recommended here?
>>>
>>>I have some problems with array as RowSource for combobox. One is that it could not handle NULL in the data. Second that it adds an empty phantom record if your ControlSource field is empty. Other than that it's fine.
>>
>> If I add an array property in my combobox baseclass and call it say "arryX(1)" , won't this cause multiple references if I have several comboboxes on the same form?
>
>No, each array belongs to its own combobox <g> If this would not be true, how can you have multiple objects of the same class on the form, such as textbox? <g>
How would I reference them in code, FOR EXAMPLE THISFORM.mycombobox1.ARRAx(1) ?
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."