Another interesting issue. DataSets and comboboxes. Problem solved, thanks Danial

Here's the issue. I populated a combobox with a "names' column from my access database. eventually most of the names will appear more than once. How do I get the names to appear in the combobox only once? Is it possible to run a loop to populate the combobox then run another loop to make the names distinct?

Quote:

---

Originally posted by BAE
Here's the issue. I populated a combobox with a "names' column from my access database. eventually most of the names will appear more than once. How do I get the names to appear in the combobox only once? Is it possible to run a loop to populate the combobox then run another loop to make the names distinct?

---

Use sql Distinct command,

E.g

Select Distinct [Names] From MyTable Order By [Names]

That will remove duplicate names.

Thanks Danial,
If I was a little smarter I would have just waited for my wife to get home. She's a SQL developer. I'm just learning this stuff, so that's my excuse. Anyway, Thanks Again. Have a Great Day.