Save listbox items to table

[Delano29]

Hi, I am using Access 2000 I have a dual multi select list box in a database which has over 30 different choices that the user can select in single or many combinations. I am having problems on figuring out how to save the selected choices to a table. This table(Table 2) is linked to a main table (Table 1). The two tables have a common field (chk_id). I need help on code to check the contents of the selected list box and the common field (chk_id) located on the form and save each item along with the ‘chk_id’ field to the table (Table 2). For instance:

Table 2:

Field Field
chk_id: selected items:
5671 Grocery
5671 Rent
5671 Loan

I would like to use a command button on the form to accomplish this task. Any help or suggestions on this would be greatly appreciated.

Thanks.

 

[Remou]

Advanced search is a good place to start, for example:
Multi-Select Property
thread705-858310