Cascade list/combo box

[Guest]

I'm not sure how to phrase my question so I'll give you some of the detail.
I have an Equipment Table and a Manufacturer Table with a many-to-many
relationship. I want to design a form that will list all the Equipment
Types. When a Equipment Type selection is made I want another list box to
have all the Manufacturers listed with those that currently have a
relationship highlighted. My objective is to let the user 1) see which
manufacturers carry a certain equipment type and 2) let users modify this
information (i.e. add or delete a manufacturer for that equipment type). Is
this type of format even possible??

(FYI - I'm back into Access after 15 years so I'm very rusty on the skills)

 

[pietlinden]

I'm not sure how to phrase my question so I'll give you some of the detail.
I have an Equipment Table and a Manufacturer Table with a many-to-many
relationship. I want to design a form that will list all the Equipment
Types. When a Equipment Type selection is made I want another list box to
have all the Manufacturers listed with those that currently have a
relationship highlighted. My objective is to let the user 1) see which
manufacturers carry a certain equipment type and 2) let users modify this
information (i.e. add or delete a manufacturer for that equipment type). Is
this type of format even possible??

(FYI - I'm back into Access after 15 years so I'm very rusty on the skills)

this article explains how to do it...
http://www.mvps.org/access/forms/frm0028.htm

 

[Guest]

Thank you for the info, however I don't think this code gets at what I really
want. As I understand it, this will only display existing relationships
between my two list boxes. --
Kelly S