I want no duplicates in my combo box

  • Thread starter Thread starter Dickbee
  • Start date Start date
D

Dickbee

I am using Access 2007 and have done the combo box but I just want to get rid
of the duplicates. I don't know code and am not real good at building events
I am a beginer
 
Create a query that uses the DISTINCT clause in it, and use that as the
RowSource, rather than the table.

Something like:

SELECT DISTINCT FieldName FROM TableName ORDER BY FieldName
 
It was unique values thanks very much

bhicks11 via AccessMonster.com said:
If you data source for the combo box is a query, click on the upper query
surface (where the tables are but outside the tables), click properties,
select Unique Records (if that doesn't do it try Unique Values - sorry I get
them confused). This should get rid of the duplicates.

Bonnie
http://www.dataplus-svc.com
Click to expand...
 
Back
Top