Getting rid of duplicate items in combo box

[tehgreatmg]

I have a from with combo boxes that have the record source set to fields in my database. The database is for computer inventory so some things like manufacturer and model repeat. I was wondering how to be able to still have the combo box set to that record source but have no duplicates in the combo box.
In other words Instead of my model combo box listing:
optiplex
latitude
optiplex
optiplex
inspiron
xps
xps

I want it to be like:
inspiron
latitude
optiplex
xps


Thanks in advanced everyone!!

[MSeda]

just add the word distinct after "SELECT" in your rowsource. SELECT DISTINCT will return each value just once.

[cyberdwarf]

Mseda is right, just be careful that your control is binding to the correct column in the combo

HTH

Steve

[tehgreatmg]

Ahh thanks soo much this saved me from ripping the rest of my hair out.

[cyberdwarf]

You still got hair!

Clearly not been working in IT too long!