Linking Combo Boxes

D

DNguon

Is There An Easy Way To Of Synchronizing A Combo Box With Another Combo Box.
A Way Other Than A Module Or Without Using VB.

I Want My Combo Box To Give Me Values Based On A Value From Another Combo Box.
 
R

Rick B

Why are you capitalizing the first letter of every word? It makes it very
hard to read.

This question is asked all the time. Do a search and read the previous
posts on "cascading combobox".

--
Rick B



DNguon said:
Is There An Easy Way To Of Synchronizing A Combo Box With Another Combo Box.
A Way Other Than A Module Or Without Using VB.

I Want My Combo Box To Give Me Values Based On A Value From Another Combo
Click to expand...
Box.
 
F

fredg

Is There An Easy Way To Of Synchronizing A Combo Box With Another Combo Box.
A Way Other Than A Module Or Without Using VB.

I Want My Combo Box To Give Me Values Based On A Value From Another Combo Box.
Click to expand...

Leave the rowsource of the 2nd combo box blank.
Code the AfterUpdate event of the 1st combo box to fill the rowsource
of the 2nd.
Something like this:
Combo2.Rowsource = "Select Instructors.InstructorID,
Instructors.InstructorName from Instructors Where Instructors.ClassID
= " & Me!ComboName & ";"

Change the table and field names as needed.
The above assumes ClassID is a Number datatype and the combo box bound
column is Number also.
 
Top