Private Sub Form_Load() Dim conn As New ADODB.Connection conn.Open "…………" '此处省略数据库连接字符串
Dim rs As New ADODB.Recordset rs.Open "select * from tablename", conn, 1, 1 'tablename是要绑定到Datacombo控件的表格的名称 Set DataCombo1.RowSource = rs DataCombo1.ListField = "colname" 'colname是要在Datacombo里显示的字段的名称 rs.Move 3 '显示第4项,rs中的记录数至少有4条 DataCombo1.Text = rs.Fields("colname") 'colname与前面的相同 Set rs = Nothing End Sub
Private Sub Form_Load()
Dim conn As New ADODB.Connection
conn.Open "…………" '此处省略数据库连接字符串
Dim rs As New ADODB.Recordset
rs.Open "select * from tablename", conn, 1, 1 'tablename是要绑定到Datacombo控件的表格的名称
Set DataCombo1.RowSource = rs
DataCombo1.ListField = "colname" 'colname是要在Datacombo里显示的字段的名称
rs.Move 3 '显示第4项,rs中的记录数至少有4条
DataCombo1.Text = rs.Fields("colname") 'colname与前面的相同
Set rs = Nothing
End Sub
Adodc1.Recordset.Move 4