Access獲取子窗體多選記錄的值

在Access中，子窗體作為記錄集作用很明顯，前面我們也講過很多關(guān)于獲取子窗體的值的問題

《Access獲取子窗體選擇的值》

《Access在父窗體中獲取選中子窗體的值》

那么如何獲取多條子窗體的記錄呢？如下圖，我們選中多條記錄

獲取多條記錄的值結(jié)果

數(shù)據(jù)表視圖中窗體多選時選定的記錄條數(shù)為Me.SelHeight屬性，然后循環(huán)獲取數(shù)據(jù)

Private Sub Form_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Dim I As Long
    Dim lRows As Long
    Dim s As String
    lRows = Me.SelHeight
    For I = 1 To lRows
'        MsgBox Me.Recordset.Fields(2)
        s = Me.Recordset.Fields(2) & ";" & s
        
        Me.Recordset.MoveNext
    Next
    MsgBox s
End Sub