I vaguely remember an option for combo boxes to set the row source to an SQL statement. Would this method have the same result? I've never actually tried to do this, so I don't know how it works.

-Michelle



>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.
>
>>>Select vac.nmbr,prlink.fname,prlink.lname Into cursor tmp ;
>>>Where vac.nmbr=prlink.nmbr
>>>Thisform.combo1.rowsourcetype=2
>>>Thisform.combo1.rowsource="tmp"
>>>Thisform.combo1.columncount=3
>>
>>Thanks. Do I place this code in the InitEvent of the form?