using combo box to select criteria

[Randy]

I have a form containing two combo boxes. I would like
the first combo box to filter out results to display in
the second combo box. Is there a relatively simple way
to do this? Thanks.

 

[Allen Browne]

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

 

[Wayne Morgan]

You will find an example of doing this here.
http://www.mvps.org/access/forms/frm0028.htm

 

[Gerald Stanley]

The usual way is to compose the RowSource SQL for the
second comboBox in the first combo's AfterUpdate
eventHandler e.g.
combo2.RowSource = "SELECT ... FROM ... WHERE aColumn = '"
& combo1.Value & "'"

If the combo1 value is a number, you omit the surrounding
single quotes.

Hope This Helps
Gerald Stanley MCSD