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

Cascading Combo Boxes - Display Linked Info

P: 2
Hi. Windows XP + Access 2002.

I have three tables.

tblMakes
=======
MakeKey (PK)
Make

tblModels
=======
ModelKey (PK)
MakeKey (FK to tblMakes.MakeKey)
Model

tblDetails
=======
DetailKey (PK)
ModelKey (FK to tblModels.ModelKey)
Description
etc etc

A form has a cascading combo that lists MakeKey and Make.
User selects the Make and cboModel lists MakeKey, ModelKey, Model.
Selecting a Model stored ModelKey in tblDetails.

When a user moves between records cboModel shows the real name for the stored ModelKey. What's not happening is that I want cboMake to show the relevant Make of vehicle depending on the value of ModelKey.

I'm stuck at the moment and have been working on this for weeks. I seem to be going around in circles.

I would appreciate any guidance in how to achieve the result I'm after.

Many thanks in advance.
Shane
Jan 28 '09 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,494
Have a look at Example Filtering on a Form, and if you're still stuck after that (It has example db and code) come back and we'll see what we can do for you.
Jan 28 '09 #2

P: 2
Tks for the response NeoPa.

I'm sorry but I don't see the relationship between the posted example and my problem. I have two combo boxes cascading. The second combo is bound to a field and shows the person friendly value while the field stores the numeric value. I need the first combo box (unbound) to display a value based on a value stored in the field that the second combo is bound to. I also need it to change as the user moves from record to record. The problem I'm mainly having is that when the user creates a new record the cascading combos break when then go to previous or first record.

I hope this helps. If not I'll attach an example.

Tks for you help.

Regards
Shane
Jan 29 '09 #3

NeoPa
Expert Mod 15k+
P: 31,494
I think I'm struggling with the idea that cascading ComboBoxes need a two-way link.

Surely, the available contents of cboModel are determined by the selected value in cboMake?

There could (should) never be a way of selecting a value of model in cboModel which does not conform to the make selected in cboMake.
Jan 29 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.