Filter by Form

[dannileeb]

I have figured out how to apply the filter in the form by command button. I have created a second command button to turn the filter off, but for some reason, I can not get it to turn off. I have tried using the event procedure. But I am sure there is a code that I just don't know how to write or use. It just needs to turn off the sorting of BoxTubeNo. Can someone help me before I give up all together?

 

[g28dman]

Dont know if this really what your looking for, I have a command button on click event procedure is:

DoCmd.ShowAllRecords

Someone else may have a better answer

 

[dannileeb]

Thanks so much. After much trial and error, that's not what they wanted the form to do.