how to update dynamically update list box values

[please help!]

Hi. I have a form with three list boxes, and a value
selection is made in each list box. However, I would like
the values in the third list box to dynamically change
based on the value selected in the second list box (ie.
each vendor only offers certain products). I have a
separate vendor and product tables, but cannot figure out
how to accomplish this.

Can anyone tell me if/how this might be possible? Many
thanks in advance for any tips/tricks/suggestions.

 

[Allen Browne]

Use the AfterUpdate event of the 2nd list box to set the RowSource of the
3rd.

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