Prev: Updating relationships
Next: Headers/Footers in Access Tables
From: TinaTechWriter on 31 Mar 2010 17:03
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.
From: Daniel Pineault on 31 Mar 2010 18:55
This is know as cascading combo boxes. See:

http://groups.google.ca/group/microsoft.public.access/browse_thread/thread/70815b1d9dbe6366/94214daf04cad326?hl=en&q=%22cascading+combo%22+%22daniel+pineault%22
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.



"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.
From: TinaTechWriter on 7 Apr 2010 13:44
Thank you!!

"Daniel Pineault" wrote:

> This is know as cascading combo boxes. See:
>
> http://groups.google.ca/group/microsoft.public.access/browse_thread/thread/70815b1d9dbe6366/94214daf04cad326?hl=en&q=%22cascading+combo%22+%22daniel+pineault%22
> 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.
>
>
>
> "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.
 | 
Pages: 1
Prev: Updating relationships
Next: Headers/Footers in Access Tables