Solved

Synchronize Three Combo Boxes

Posted on 2004-08-27
1
300 Views
Last Modified: 2008-03-06
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
0
Comment
Question by:zamoraa
1 Comment
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 50 total points
ID: 11918107
Same question asked here:
http://www.experts-exchange.com/Databases/MS_Access/Q_21109886.html

You should be able to follow the answer given there I think.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now