combo box question

[Drowning]

The combo box is named Region. I want it's drop down to display each region once... so it can act as a filter. How do I tell it to group the regions.
I'm obviously a beginner... and need a clear and detailed solution.
Thanks
Drowning

 

[Ken Snell]

Use a query similar to this:

SELECT DISTINCT [Region] FROM TableName;

--

Ken Snell
<MS ACCESS MVP>

The combo box is named Region. I want it's drop down to display each

region once... so it can act as a filter. How do I tell it to group the
regions.