Link to home
Start Free TrialLog in
Avatar of zamoraa
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
ASKER CERTIFIED SOLUTION
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial