Microsoft Access: Filter a subform by the value of a control

Platform:Microsoft Access
Task:Filter a subform by the value of a control
Discussion:
You need to filter a subform based on the value of a control such as a listbox or combo box.
Example:
Private Sub List4_AfterUpdate()
    Dim filter As String
    filter = "Category = '" & List4.Value & "'"
    frmItems.Form.filter = filter
    frmItems.Form.FilterOn = True
End Sub
Back to Index