[求助]在access中在同一个窗体中如何动态更改数据源?

fan0217

    Dim strNewRecord As String
    strNewRecord = "SELECT * FROM Customers " _
        & " WHERE CustomerID = '" _
        & Me!cmboCompanyName.Value & "'"
    Me.RecordSource = strNewRecord
更改窗体RecordSource 属性即可。