Access設(shè)置窗體記録源及綁定控件的數(shù)據(jù)源

在應(yīng)用程序中， 窗體顯示數(shù)據(jù)需要綁定記録源。在access中可以直接在屬性中綁定窗體的記録源，也可以通過代碼設(shè)置

1.綁定窗體記録源，文本框控件對應(yīng)顯示的控件來源

2. 用DAO代碼綁定

Private Sub Form_Load()
    Dim db As DAO.Database
    Dim rs As DAO.Recordset
    '穫?cè)〔樵冎械挠涘h集
    Set db = CurrentDb
    Set rs = db.OpenRecordset("Q_員工工資", dbOpenDynaset)
    '設(shè)置查詢的記録集爲(wèi)當(dāng)前窗體的記録集
    Set Me.Recordset = rs
    '設(shè)置當(dāng)前窗體中兩箇文本框的數(shù)據(jù)源
    With Me
        .txt_姓名.ControlSource = "姓名"
        .txt_工資.ControlSource = "實得工資"
    End With
    Set rs = Nothing
    Set db = Nothing
End Sub