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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brook - 21 Apr 2005 06:55 GMT

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

Reply to this Message

Graham Mandeno - 21 Apr 2005 11:39 GMT

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;

Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

> Hello All...
>
[quoted text clipped - 9 lines]
>
> Brook

Reply to this Message

Klatuu - 21 Apr 2005 23:01 GMT

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.

> Hello All...
>
[quoted text clipped - 9 lines]
>
> Brook

Reply to this Message