>Chuck,
>
>It would be better encapsulation to put this code in the Init event of the combobox itself:
>
>
with this
> select ...
> .RowSourceType = 2
> .RowSource = "tmp"
> .ColumnCount = 3
>endwith
>The object ought to do the work to get itself going. The form shouldn't be responsible for it.
David,
You are certainly right, but even if the form's events were to be used the Init is too late. It would be better to put the select command in the Load so the cursor exists when the combo is created.