listbox items to Access database

[silvertrip]

I am trying to figure something out. Maybe someone can help.

I have two listboxes (one I populate with items, and the 2nd is for when the user selects items). I can add items from the first listbox to the second, but my problem is saving the contents of 2nd listbox to a database.

If someone could help me out, I would be very thankful because I am still sorta new to programming with databases.

 

[vbSun]

Depends on how your DB structure is..

You can create many rows to the table (Multiple insert statements), or you can save just one row with all the selected items/ids after concatenating them and adding a delimiter between each of them.

------------------------------------------
The faulty interface lies between the chair and the keyboard.