limit combo box to unique values

[Bill0722]

I have a combo box that looks up the date a table entry was created. Of course several entries could all have the same date. I want to limit the combo box to showing only one of each date
In table 7/1/2006
7/1/2006
7/2/2006
7/2/2006

I want the combo box to only show
7/1/2006
7/2/2006

Thanks,

 

[yummy7]

Write Distinct keyword with date field in your query.

 

[rjoubert]

Or you could put the DISTINCT keyword in the Row Source of your combo box (after SELECT).