zamoraa
asked on
Synchronize Three Combo Boxes
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
Name: Departments
RowSourceType: Table/Query
RowSource: tbl_Departments
ColumnCount: 2
ColumnWidth: 0";1"
BoundColumn: 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)
End Sub
COMBO BOX 2
Name: Divisions
RowSourceType: Table/Query
ColumnWidths: 2"
Width: 2"
COMBO BOX 3
Name: Classifications
That is all I have, can someone please help.
Thank you very much.
AZ
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
Name: Departments
RowSourceType: Table/Query
RowSource: tbl_Departments
ColumnCount: 2
ColumnWidth: 0";1"
BoundColumn: 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)
End Sub
COMBO BOX 2
Name: Divisions
RowSourceType: Table/Query
ColumnWidths: 2"
Width: 2"
COMBO BOX 3
Name: Classifications
That is all I have, can someone please help.
Thank you very much.
AZ
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.