I need to know how (if possible) to make a for that has two list boxes on it that act in the following way:

I need to have one list box have a list of values in it. I need to be able to select on of the values, and have the second list box adjust it's contents.

For example:

if list box A contains a list of computer parts, and list box B contains a list of manufacturers. A selection of "mouse" in list box A, should cause list box B to only display a list of Manufacturers who make the type of part selected in list box A. (the actual relationships can be done in a simple query, and i know how to do that)


I hope that i gave enough information, thanks in advance for any help that i can get!

Base ListBox B on a query that includes a join of Parts and Manufacturers.

In the criteia under Part, reference LixBox A like this...

Forms!FormName!ListBoxAName.

Back on the form on the AfterUpdate event of ListBox A put...

ListBoxBName.Requery

hth