Remove filter from 2 subforms

  • Thread starter Thread starter Ryan Tisserand
  • Start date Start date
R

Ryan Tisserand

The code below should remove the filters from both subforms, but it only
removes the top one listed. I need both to be removed and all records shown
on each subform. Thanks for any help.

Private Sub RemoveFilter_Click()
Me.DateFilter.Value = Null
Me.StartDateFilter.Value = Null
Me.EndDateFilter.Value = Null
Me.CheckFilter.Value = Null
Me.LOFilter.Value = Null
Me.AccountFilter.Value = Null
Me.PayeeFilter.Value = Null
Me.PaymentFilter.Value = Null
Me.StatusFilter.Value = Null
Me.VoidedFilter.Value = Null
Me.C25DepositsSF.Form.FilterOn = False
Me.C25TransactionSF.Form.FilterOn = False

End Sub
 
I once again figured out my own problem. Here was my solution.

Private Sub RemoveFilter_Click()
Me.DateFilter.Value = Null
Me.StartDateFilter.Value = Null
Me.EndDateFilter.Value = Null
Me.CheckFilter.Value = Null
Me.LOFilter.Value = Null
Me.AccountFilter.Value = Null
Me.PayeeFilter.Value = Null
Me.PaymentFilter.Value = Null
Me.StatusFilter.Value = Null
Me.VoidedFilter.Value = Null
Me.C25TransactionSF.Form.FilterOn = False
Me.C25DepositsSF.Form.FilterOn = True
Me.C25DepositsSF.Form.FilterOn = False

End Sub

I guess by turning the filter back on first then allows you you to turn it
back off.
 
Back
Top