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