Hi, I've been having trouble with my filter not clearing properly. Essentially what I have is a split-form which displays all the appointments for a certain location when I click a "View Schedule" button. This works, but I also have a "View All" button to take me back to show all my records and remove any filters.
This is my code for "View All"
Private Sub View_All_Click()
DoCmd.ShowAllRecords
Me.FilterOn = False
Me.Filter = ""
Me.OrderBy = ""
End Sub
The problem is if I click "View Schedule" again with different day(s) in my combo boxes, then the previous filter is applied, no matter what I do (even with the Clear All Filters under Advanced). The filter will only "disappear" when I close the form and re-open it fresh.
This is my code for "View All"
Private Sub View_All_Click()
DoCmd.ShowAllRecords
Me.FilterOn = False
Me.Filter = ""
Me.OrderBy = ""
End Sub
The problem is if I click "View Schedule" again with different day(s) in my combo boxes, then the previous filter is applied, no matter what I do (even with the Clear All Filters under Advanced). The filter will only "disappear" when I close the form and re-open it fresh.