Filter button w/ pop-up dialog?

[10 Gauge]

I am curious if there is a way to create a form button that when clicked will prompt the user to enter data to filter the form results by?

I have a purchase order database and want to be able to filter records by a particular repair order # so that it only shows all PO's associated with the given RO.



Thanks in advance for any help if this is possible.

[10 Gauge]

Alright figuring it out through some messing around....

Here's what I have so far:

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?