By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,099 Members | 947 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,099 IT Pros & Developers. It's quick & easy.

Combo Box question

P: n/a
Here is my situation:

I have two tables linked together in a many-to-many relation through an
interum table. It looks like this...

Title TitleTopic Topic
----- ---------- -----
TitleKey-------| TitleTopicKey |--------TopicKey
TitleName |-----TitleID | TopicName
CreationDate TopicID------------| CreationDate
etc... etc...

I have two combo boxes. The first shows all records in the Title table,
no problem there. I want the second combo box to display the related
records in the Topic table based on what the user selects in the first
combo box. How do I go through the interum table to get the related
selection of the Topic table loaded into the second combo box??

Thanks!

Paul
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sun, 06 Feb 2005 16:59:04 -0600, Access User wrote:
Here is my situation:

I have two tables linked together in a many-to-many relation through an
interum table. It looks like this...

Title TitleTopic Topic
----- ---------- -----
TitleKey-------| TitleTopicKey |--------TopicKey
TitleName |-----TitleID | TopicName
CreationDate TopicID------------| CreationDate
etc... etc...

I have two combo boxes. The first shows all records in the Title table,
no problem there. I want the second combo box to display the related
records in the Topic table based on what the user selects in the first
combo box. How do I go through the interum table to get the related
selection of the Topic table loaded into the second combo box??

Thanks!

Paul


Change the table and field names as needed.

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.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.