First record in recordset selected

F

faberk

I have a combo box that contains the following "after update" event procedure:

strSQL = "SELECT tblSubRegions.SubRegionId,
tblSubRegions.SubRegionDescr, tblSubRegions.CopTpart,
tblSubRegions.SubConfCurr, tblSubRegions.SubRegEmail " _
& "FROM tblSubRegions " _
& "WHERE ((tblSubRegions.RegionId)=" & cboRegions & ");"

Me!lstSubregions.RowSource = strSQL

The procedure updates the rowsource of the "lstSubRegions" list box. I
would like to have the first record in the listbox selected after each
update. How can I do this?
 
Top