Select values from table into Combo Box.

[Guest]

Hi All !

I have a table with only two fields, "Make" and "Model".
In a form, I need 2 Combo Boxes with these values. This is the easy part.
What I need to do and don't know how is, after selecting a value on the first
box, the second box will only show me matching records.

Example.
Make Model
Nokia 6100
Sony T630
Nokia 3660
Sony K750i

If I select "Nokia" on the first combo box, I only want to see Nokia Models
on the second box.

I'm pretty sure this has to be done with a query, I just don't know how.

Any help will be much appreciated.

Best Regards,
Rogerio.

 

[Allen Browne]

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