I want no duplicates in my combo box

[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

 

[Douglas J. Steele]

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

 

[bhicks11 via AccessMonster.com]

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

 

[Dickbee]

It was unique values thanks very much

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

 

[bhicks11 via AccessMonster.com]

Good, good!

It was unique values thanks very much

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,

[quoted text clipped - 7 lines]