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]

Re: Subquery in a form...

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" <lupo666@libero .it> wrote in message
news:e3633d6a.0 405020024.3093a 381@posting.goo gle.com...[color=blue]
>
> 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[/color]