Move data from listbox to table

[Justinti]

Hello,

I have two listboxes on a form listbox1 and listbox2. listbox1 is populated by table1 which has 40 fields and 1000 records. listbox2 is populated by table2 which has identical structure to table1(same fields) but has no records.

For both listboxes Multi Select is set to simple. Rowsource is Select * statement from tables. Row Source Type is set to Table/Query.

I would like to select multiple records from listbox1 and add them to listbox2 and table2 or just table2. After selecting the records from listbox1 the user will click a button to add the records to table2. Also need to delete the values selected from table1 on same button click.

Need help with the code. Can you please be very detailed in your explanation.

The database is saved with a .mdb file extension.

 

[jdraw]

I don't follow the need for list boxes and tables. I'm going to point you to a video tutorial that deals with listboxes.

One listbox shows generally - available Options, the other shows Options Selected.
You can select/deselect and the option goes to the other listbox.

 

[Justinti]

@jdraw

The need for list boxes and tables is for the user. The tables already exist a. List boxes make it easy for the novice user/client to move records from table to table. Table 1 is historical data and table 2 is current data.