Remove Duplicates in a Combo Box

[DivideMySky]

Hey Everyone -

Im trying to populate a combo box from a table column that has duplicate information in it, but I only want the combo box to display single entrys even if there's more than one in the table. ANy help on how to do this? I tried using SELECT DISTINCT instead of just SELECT, but it doesn't seem to make any difference. Thanks!

TJ

 

[Blorf]

When all else fails, I use a field in my query, ie sum (1) as count.

That seems to make the dups go away, even when access is acting wierd.

ChaZ

 

[dhookom]

Next time, it would help if you provided at least the SQL of your Row Source property. Have you tried making the Row Source query into a Totals Query?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]