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

[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, but this forum won't support attachments that size.

-Thanks!

 

[dcx693]

Have you tried searching the forums for your answers?

(1) Try searching on cascading combo boxes, and look at the entry in the FAQ section.

(2) change the queries feeding the combo boxes to make them select unique entries. Search on SELECT DISTINCT as well as unique combo box entries, etc...