Linking list box to combo box

W

WoodyAccess

I have a subform which is a many-to-many relationship. The subform contains
only two things - a combo box (containing products) and a multiple select
list box containing information related to that product.

The product, selected by a unbound combo box in the header, is linked so
that the product in the main and subform show information only for that
product. However when I select mulitiple options from the subform list box
when I change the product the same selected boxes stay selected for every
product rather than just the product I wanted the selection for.

How can I make a multiple selection in the list box and keep it only for the
product specified??
 
Top