I'd like to know if someone has some code that would do the following:
I have a part form/table and an Assembly form/table. A part can be available for some assemblies but not for others (a one to many relationship). In my Part form, I would like to have the user select the assemblies for which this part is available. It can be one assembly or many. I would like to show that in a multi select list box instead of using the standard main/subform trick.
What I'm looking for is some code that would read my table in order to build the list box when the form loads and code that would write/update the table according to what is selected in the list box.
Thanks to all
I have a part form/table and an Assembly form/table. A part can be available for some assemblies but not for others (a one to many relationship). In my Part form, I would like to have the user select the assemblies for which this part is available. It can be one assembly or many. I would like to show that in a multi select list box instead of using the standard main/subform trick.
What I'm looking for is some code that would read my table in order to build the list box when the form loads and code that would write/update the table according to what is selected in the list box.
Thanks to all
