代码这样写,写到afterload事件里去
Dim c As Integer= Tables("活动.报名表").Rows.count '将行数赋值给c
Dim ids As String
If c > 0 Then '如果Tables("活动.报名表")行数>0
For Each r As Row In Tables("活动.报名表").Rows '遍历 Tables("活动.报名表")
ids = ids & "," & r("id")
Next
ids = ids.trim(",")
e.Form.Controls("人员").Table.Filter=" [_Identify] not In (" & ids & ")"
Else
e.Form.Controls("人员").Table.Filter=""
End If