combo box select unique

  • Thread starter Thread starter eb1mom
  • Start date Start date
E

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
 
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,
 
-----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
.
Click to expand...
 
Back
Top