>>> ControlSource = variable ending up with value
>>
>>Maybe I am wrong, but how can you make the sourcecontrol of a combobox a variable? An Array possibly? Otherwise in my opinion if you have a variable as rowsource of a combobox you have 1 entry only. Something basicly wrong with Douglas' code, like Tamar pointed it is hard to say what he is doing.
>>
>>Regards,
>>
>>Koen
>
>ControlSource, not RowSource. Still, my suggestion is to use a field in a cursor rather than a variable to avoid these problems.
ОК, even if we don't want to bind it to a field, it can be bound to a form property. Binding to variables sounds like 2.6 technique, which then means that the variables need to be in scope when the form instantiates - with the event model in place, they either need to be public, or the form needs to be modal. Both ways it's just bad in today's terms.