Question Control Box with no Duplicates

[Ineedcoffee]

Hi,

I have a bit of a strange question. I have a split form/datasheet that shows details of our customers with certain fields on (such as First/Surname, Status of order, Area of Order, Sales Person etc) and I want to be able to make it easier to filter the data.

As it stands, you can filter by one field and to filter anything else you need to put in a text filter. All i want to be able to do is create a Control Box with a drop down list of the values in the fields (with no duplicates) and then on update run a macro that does an Applyfilter with the selection the user has made.

Is this possible?


Many thanks,

Ineedcoffee

 

[John Big Booty]

You can create a combo box that is populated by a Group By (sum Σ) query that groups which ever field you like. You should then be able to pass that to your filter.

 

[Ineedcoffee]

So just to clarify, I would need to create a query for each field I want to filter by and use that?

Also just a thought, would I need to set up an on update macro in the control box to set a TempVar to the user selection so it can run the apply filter command?

Thanks.