combo box? multiple identicle entries... only one selection?

[Guest]

Hello All...

I have a combo box that I use for a search feature on form for a field
'size' from form orders.

I want the combo box to just show one value for each of size rather that
each item that has a size?

I hope this is clear ?

Any ideas ? Suggestions?

Brook

 

[Graham Mandeno]

Hi Brook

Add the keyword "DISTINCT" to the SQL statement in the RowSource of your
combobox. For example, instead of:
Select Size from MyTable;
use this:
Select distinct Size form MyTable;

 

[Guest]

If your query is SQL, then Graham's suggestion should do the trick. If you
used QBE to create your query, then go to design mode, click the Totals
Button, and set the Totals row to Group By.