Saving items from a listbox selection

[mghdb]

Hi All, I have a listbox that a user can select various items, On the same form I have a textbox that shows what items have been selected. My problem is that how do i save the items that appear in that textbox into a table ? I've tried some Sql statements but can't seem to make it work. Please help ! Below is a sample of the code i've been playing with. Any suggestion will help.

Dim strSql as string
strSql = "Insert Into tblStorage (Field 1)"Select " & Me!txtBox6 &"
docmd.runsql strSql

 

[llkhoutx]

Use DAO code to append a table recordset with the values in your listbox.

 

[mghdb]

llkhoutk, thank you for your response. can you further explain. i'm kinda a novice so if you can explain in detail that would be helpful.