Filter list macro

[leo31]

How do I create a Form Filter based on list option?

Can I create a macro to apply a form filter using a value from a selection list.

IE, instead of applying a filter to a form were the Category field = One, can the filter start to run and return a list One, Two, Three, so I can then select Two for the filter, and then next time maybe One?

 

[ajetrumpet]

You'll have to be more specific here Leo. The description you have given of the process is a bit confusing...

 

[leo31]

ok, I'll try.

i have a continuous form containing information like, PhotoTitle, Location, LimitedEdition and a field called Category.

This Category field will be a combo box containing values like, Landscape, Architecture, Wildlife etc...

I would like to place a button on the form to apply a filter based on Category, IE show only landscapes. But I would like the filter to give all the options, allowing the user to choose how to filter the list of records.

So the user clicks filter, and it says, Landscapes : Architecture etc.. and they choose how that want filter it.

i then need a show all records button.

I hope this helps