Thanks Sergey. That works fine.

>Add INTO CURSOR clause

... INTO CURSOR crsCombo1

>>What is the correct way to programmatically set the source of a combobox if the source is to be a sql select statement?
>>I have
>>

>>thisform.cboStreet.RowSourceType = 3
>>thisform.cboStreet.RowSource = 'select distinct st_name from linkfile order by st_name'
>>

>>but this produces a browse when the SELECT fires. Should it be selected into a cursor instead and use the ALIAS as the rowsource?
>>
>>Thanks
>>
>>
>>