Remove Duplicates from Combo Box

[Shaitan00]

Given a form [frm1] which contains a data combo box [dcb].
On form load the combo box is populated with a recordset (Records) containing all rows from my SQL Table. The combo box displays Column(1) only, however this field contains duplicates which I do not wish to display.

Code used:
Set dcb.RowSource = Records
dcb.ListField = Records(0).Name

How could I modify my code to ensure that no duplicate names appear in my combo box?

[Memnoch1207]

You'll need to use a SELECT DISTINCT query for the adCommandText.