Remove filter from 2 subforms

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
 
R

Ryan Tisserand

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If else subform reference access 2007 2
Selecting current record in subform after removing filter 1
Removing filter from multiple subforms 9
Help with WHERE filter on opening report from dialog 4
Yet another filter Subform by Combo Box 1
Error 3048 "Cannot open any more databases" 7
ApplyFilter event on a subform 1
Pass Subform filter to subform in report 0

Top