Alright figuring it out through some messing around....
Here's what I have so far:
Code:
If Me.FilterOn Then
Me.FilterOn = False
Else
Me.Filter = "RO_Number = [RO Number]"
Me.FilterOn = True
End If
The only problem is that once I click the button again to unfilter, and then click the button once more to search for another RO Number it uses the previously entered RO Number and does not prompt the user to enter a new number?
I assume there is one short line of code I can add after the "Me.FilterOn = False" expression that will reset the filter to null?