Setting values of 2 combo boxes w/ same row source and eliminating dup

[etalent]

I've got two combo boxes that work really closely to what I want, but they've still got 2 problems:

(1) When you make a selection with one combo box, the value of the other combo box should be (programatically) set, but as it is now I have to select the right value from each combo box individually.

Both combo boxes get their values from the same table, same record, but different columns, so it seems easy that when the value of one combo box gets set, the other should too automatically.

(2) Both combo boxes have duplicates in their drop down lists. How do I fix that?

My database is only 250 KB. Pleaes let me send it to you.
-Thanks!

 

[mndrlion]

To eliminate duplicates in the combo box, make the Row Source of the combo box look something like this:

SELECT DISTINCT fieldName FROM tableName.

To automatically update comboBox2, you will need to write some code in one of the events for comboBox1. I find that the AfterUpdate event is usually a good choice.