best way to group combobox choices?

[krberube]

I have a combobos using a table to look up its values, no problem. The table could have several identical values to place in the combo box ( same city, State multiplt times). I want to group these so that the city, state will only show once in the combobox, hence makiing the list a little shorter. is the best way to do this by creating a new query to group the choices and base my combobox off this new query? or is there another way from within the combobox properties?

Thanks all
Kevin

 

[maxmangion]

i think your main issue here is normalisation. Don't you have a particular table, where you only distinct cities / states ?

Having such table, then you would be able to build your combo box from this table ... thus avoiding you identical values problem.

 

[krberube]

I believe you are correct with that, and on that note I wish I did have a table like that. I am using access to run custom reports off of our internal tracking system ( linked table mostley). This system is from Best software ( sage?) and is severly limited.
So with no table like this....i'm stuck, and think that this may be my only choice?

 

[maxmangion]

you might also try putting the word DISTINCT in your SQL statement of your query i.e. Select Distinct .... from .... etc