I can fill a datacombo at design time using adodc but not at runtime using the code below. The recordset has records in (i've checked using the immediate pane), but no records are displayed in the datacombo itself.
Option Explicit
Private Sub Form_Click()
Dim myrs As ADODB.Recordset
Set myrs = New ADODB.Recordset
myrs.Open "Select * from career_officers", _
"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CSRSRep;Data Source=DEVSRV1"
Set DataCombo1.RowSource = myrs
DataCombo1.ListField = "name"
End Sub
