>>>Same result....NumberOfElements reset to default was the same as setting it to zero. FirstElement is still on default.
>>
>>Also, instead of binding to the variable, bind to the cursor's field.
>
>Naomi,
>
>
>> 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.
If it's not broken, fix it until it is.
My Blog