Choices to display dependent on previous choices...

[TinaTechWriter]

I've been trying to find this answer in the Help and in the forums, but must
be using the wrong terminology.

My form has a drop down field called "1." and a drop down field called "2.".
I want to do something like this:

Field 1:
A.
B.
C.


If you choose A. then Field 2 populates with specific choices, if you choose
b. then those choices are different etc.

So:

Field 1 Field 2
A. a.
b.
c.

B. d.
e.
f.

C. g.
h.
i.

What is this called and/or how do I do it?

Thank you in advance for any suggestions.

 

[Daniel Pineault]

This is know as cascading combo boxes. See:

http://groups.google.ca/group/micro...6?hl=en&q="cascading+combo"+"daniel+pineault"
http://www.rogersaccesslibrary.com/forum/topic389.htm
http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[TinaTechWriter]

Thank you!!

This is know as cascading combo boxes. See:

http://groups.google.ca/group/micro...6?hl=en&q="cascading+combo"+"daniel+pineault"
http://www.rogersaccesslibrary.com/forum/topic389.html
http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.