Populating lst Box

[Chad]

I have 2 list boxes (lst1 and lst2 for example's sake) on a form, both of
which can have multiple selections. I would like to poplate the contents of
lst2 with a query that is based on what is selected from lst1.

For Example:

If Apples, Oranges, and Bananas are selected in lst1.....

I would like to use that criteria in a query to extract data from a table
that might have the fruit's colors..... so lst2 would contain Red, Orange,
and Yellow.

Is there a way to do this?

Thanks,
Chad

 

[Allen Browne]

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