Synchronize Three Combo Boxes
Posted on 2004-08-27
I am trying to synchronize three comob boxes and can do two using the Q209595 help file from Microsoft's online support. I also tried using the solution to question "How Do I Synchronize Three Combo Boxes" but have not been successful.
My first combo box is Departments, the second is Division and my third is Classifications. This is how the properties in my combo boxes look like:
COMBO BOX 1
AfterUpdate: [Event Procedure]
Private Sub Departments_AfterUpdate()
Me.Divisions.RowSource = "SELECT Division FROM" & _
" tbl_Divisions WHERE DeptID = " & Me.Departments & _
" ORDER BY Division"
Me.Divisions = Me.Divisions.ItemData(0)
COMBO BOX 2
COMBO BOX 3
That is all I have, can someone please help.
Thank you very much.