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.

This is know as cascading combo boxes. See:

http://groups.google.ca/group/micros...el+pineault%22
http://www.rogersaccesslibrary.com/forum/topic389.htm
http://office.microsoft.com/en-ca/ac...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" wrote:

> 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.

Thank you!!

"Daniel Pineault" wrote:

> This is know as cascading combo boxes. See:
>
> http://groups.google.ca/group/micros...el+pineault%22
> http://www.rogersaccesslibrary.com/forum/topic389.html
> http://office.microsoft.com/en-ca/ac...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" wrote:
>
> > 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.