Cascading Combos

[mHalvy]

Okay, so I'm fairly "new" to access and read all of these posts about
cascading combos, and see all the random query strings thrown around, and
wonder what? I need some help trying to create a cascading combo, but in
simple laymans terms or step by step instructions. My employer needs me to
create a database, and I am self taught, but I have not really looked into
the cascading combos thing, and I need it. So any help would be appreciated.
Thanks.

 

[Douglas J. Steele]

See whether
http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033
helps

 

[Jeff Boyce]

Why do you think you need "cascading combos"? (I'm not asking to be curious
or pushy, but to see if the "tool" you've picked is the right one for the
"job" you have...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[mHalvy]

Well, my supervisor has asked me to make these "drop down lists". They are
for a public comments database.Anyways for some background, a document has
been published and we will be receiving public comments on the document. And
we want to organize these comments by their content, i.e. whether they refer
to chapter one, and maybe some of chapeter one's sub sections so to speak, so
for example say chapter one is entitle Public Lands and within that chapter
there will be a section called Recreational Public Lands" one "Wilderness
Study Areas" etc. And it is highly possible the "sub sections so to speak
will have sections within them as well. Now with all of that said my
supervisor wants these comments in a database and he wants these drop down
list, or combo boxes, to be populated by what chapter is selected. So if
chapter one is selected in the first combo box, then the next one lists the
sub categories and so on. This is the reason I need these, and I'm not
understanding how they work or how to make them and write the proper SQL
code. Don't bother with Visual Basic, unless it is explained for
understanding, cause I don't know a thing about VBA.

 

[Jeff Boyce]

Thanks for the further clarification.

Doug Steele offered a good pointer to how to base one combo box on another.

However, if you want "cascading combo boxes" to work, you WILL have to do a
bit of VBA coding.

Regards

Jeff Boyce
Microsoft Office/Access MVP