469,271 Members | 1,466 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Getting rid of duplicate items in combo box

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!!
Jan 18 '07 #1
4 12272
MSeda
159 Expert 100+
just add the word distinct after "SELECT" in your rowsource. SELECT DISTINCT will return each value just once.
Jan 18 '07 #2
cyberdwarf
218 Expert 100+
Mseda is right, just be careful that your control is binding to the correct column in the combo

HTH

Steve
Jan 18 '07 #3
Ahh thanks soo much this saved me from ripping the rest of my hair out.
Jan 18 '07 #4
cyberdwarf
218 Expert 100+
You still got hair!

Clearly not been working in IT too long!
Jan 18 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by 6thirty | last post: by
4 posts views Thread by Shi Mu | last post: by
1 post views Thread by Gian Paolo | last post: by
4 posts views Thread by R.Manikandan | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.