Combo/List Box - Trigger secondary List/Combo Box?

[Guest]

I hope there's a guru out there that can either tell me this is do-able or not.

I have an 'error' database that has a combo box for the user to select what
type of error was made, what I would like to do is based on the selection
made in that combo box have a "sub-box" pop up and ask for the detailed
information of the error, also a finite list of answers.

Is this possible? I've tried creating it using the sub-form feature, but
either I'm not setting it up correctly, or it's not what I am looking for -
the subform always shows up on my original form, and I only want it to appear
based on what is selected in the combo box to begin with.

I hope this makes sense - if this is possible it would be a HUGE help -
thanks to anyone who can assist!

 

[Guest]

Hi Doreen,

This link may give you what you are looking for:

http://support.microsoft.com/kb/q97624/

 

[Sam Hobbs]

Also see the CascadingComboBoxes sample at:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=CascadingComboBoxes.mdb

I think it might help too.

However there seems to be an inconsitency between the subject "Combo/List
Box - Trigger secondary List/Combo Box?" and the description of the problem.
In the description below, you seem to say you need a subform, not a
secondary List/Combo Box. However perhaps you intend to do both; have a
secondary List/Combo Box but also a subform that is dependent on the primary
List/Combo Box. So if you do need a secondary List/Combo Box then perhaps
you can clarify the question.

 

[Sam Hobbs]

I notice that that KB article applies to versions of Access prior to 2000.
Is there a separate KB article that is for Access 2000 and/or 2002? Or has
Microsoft just not revised the list of software that the article applies to?