combo box select unique

[eb1mom]

I have a combo box that shows product manufacturer names.
when you click on a name it brings up all records for that
manufacturer. How do I make the combo box only show each
name once? I know it has to do with select unique but,
can't get code written correctly. Any help would be
appreciated. thank-you

 

[Cheryl Fischer]

Instead of UNIQUE, you need to use DISTINCT ...

In the RowSource property of your combo box, you will need a query that
looks something like:

Select Distinct MfrName from MyTable order by MfrName


hth,

 

[Guest]

-----Original Message-----
I have a combo box that shows product manufacturer names.
when you click on a name it brings up all records for that
manufacturer. How do I make the combo box only show each
name once? I know it has to do with select unique but,
can't get code written correctly. Any help would be
appreciated. thank-you
.

 

[Guest]

Thanks that works.