... 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?
>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?