Subquery in a form...

[Dr. Roberto VALENTE]

Hi all,

I have a form to input clients data and two fields are "Car Brand" and
"Car Model", both taken from an external table containing the two
fields... It works fine, but I would like to subquery the second field
based on the first one: if one inputs "Ford" as brand, I would like to
just view the Ford models in the "Model" section, instead of all of
them... can't figure it out :-(((

Thanks in advance to everybody for any help you can provide, Lupo

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dr. Roberto VALENTE" <lu*****@libero.it> wrote in message
news:e3**************************@posting.google.c om...

I have a form to input clients data and two fields are "Car Brand" and
"Car Model", both taken from an external table containing the two
fields... It works fine, but I would like to subquery the second field
based on the first one: if one inputs "Ford" as brand, I would like to
just view the Ford models in the "Model" section, instead of all of
them... can't figure it out :-(((

Thanks in advance to everybody for any help you can provide, Lupo