Filtering Problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Group

I have pasted code below. I can't get all of the filters to turn off
it seems that only the first and second one turn off but not the third. I
have used this in a click event and it didn't work then I pasted it into a
module and it didn't work either. Could this be possibly because the names of
the last two are identicial up to the "Large and Small" and then VBE thinks
they are the same control?

Thanks
Mike


Public Sub codAllFiltersOff()
Forms![frmWIPExplorer]![sfmCompanyNames].Form.FilterOn = False
Forms![frmWIPExplorer]![sfmShopOrderNumbersLarge].Form.FilterOn = False
Forms![frmWIPExplorer]![sfmShopOrderNumbersSmall].Form.FilterOn = False
End Sub
 
I have changed the names of the sub-forms and it doesn't seem to have an
effect on it. I noticed that if my code sets the filters for all of them i
can turn each one off independantly of one another but I still have to run
the code that sets the filter between them. It's like its losing it ability
to navigate without producing and error. I know it is probably something I
didn't do correctly. Any ideas?
 
Back
Top