Filter Button In Form

[Guest]

I am looking to create three buttons in my form that creates three different
filters? Is there anyway of doing this without having to manually select
fields each time? Can I have them linked to a query or something?
Just for a bit more info...I want the buttons to filter out my Yes/No check
boxes for A Prospect Customer, a Pending Customer, and a Sold Customer; so
when I click the button I am able to use my "Next/Previous" button and scroll
through each of the customers.

 

[Guest]

Let's say you have 3 fields ysnProspect, ysnPending and ysnSold.
Let's say you also have 3 buttons btnProspect, btnPending, btnSold.

In the click event of btnProspect:
Me.Filter = "[ysnProspect] = " & True
Me.FilterOn = True

In the click event of btnPending:
Me.Filter = "[ysnPending] = " & True
Me.FilterOn = True

In the click event of btnSold:
Me.Filter = "[ysnSold] = " & True
Me.FilterOn = True

Steve