Columns in a Listbox

[craigalaniz]

Hi All

I am trying to get the selected data from a listbox to insert into a table. I am only able to get the first column into the table. I am not sure how to select columns 2 and 3.

Dim sql As String

sql = "INSERT INTO [CHS negotiator] ([Staff ID#], [Staff Last Name], [Staff First Name]) VALUES ('" & List4 & "', '" & List4 & "', '" & List4 & "');"



CurrentDb.Execute sql



Thanks

Craig

[NTC]

from a listbox?

so where is the data to begin?; in order for it to be in a listbox it must already be in a table - - unless you've manually typed it into the listbox properties....

[craigalaniz]

Thanks for your reply. The listbox is getting data from a SQL Server table. (List of all employees). I need for the user to be able to add one of these employees to a table that is in Access when needed.

Thanks

Craig

[RuralGuy]

The ListBox control has a Column() property that is 0 based so Me.ListBoxName.Column(2) is the 3rd column.