我就是想向过程传入一个集合,让数据集当前记录填充进集合里,而我现在传入的集入是窗体的控件集合!但不局限于些,任何集合都可以!Public Sub FullRecord(colls As Collection, rs As ADODB.Recordset)
Dim coll As Collection
For i = 0 To rs.Fields.Count - 1
For Each coll In colls
If rs.Fields(i).Name = coll.Name Then coll.Value
Next
Next
End Sub
Dim coll As Collection
For i = 0 To rs.Fields.Count - 1
For Each coll In colls
If rs.Fields(i).Name = coll.Name Then coll.Value
Next
Next
End Sub
直接用不就行了吗???Public Sub FullRecord( rs As ADODB.Recordset)
dim a as Control
For i = 0 To rs.Fields.Count - 1
For Each a In Form1.Controls
If rs.Fields(i).Name = a.Name Then a.Value
Next
Next
End Sub
dim a as Control
For i = 0 To rs.Fields.Count - 1
For Each a In CurForm.Controls
If rs.Fields(i).Name = a.Name Then a.Value
Next
Next
End Sub