Listbox with check boxes and saving the selection

[Shamli]

Hi
I want a list box with many columns and upon selection the data has to be stored on the table using a append query.

Explanation:


I have list box which takes the data from "Project table" with columns : Element, Project name ElementId, ProjectID etc.
1. I wanted to have a checkbox in the list box . so that the user can select multiple items. I have tried "Simple" in multiselect option. I feel like its not user friendly. (selection doesn't go off after refreshing etc.)
2. Upon selection through check box, it has to saved in another table (Emp to project) with all the columns respectively.

I am not sure how to proceed with it. Please help in solving this problem.

[June7]

This is not possible with listbox control. A combobox bound to a multi-value field will have checkbox. However, I do not recommend multi-value field.

A listbox does have multi-select capability, just cannot have checkbox in it.

[pbaldy]

This may help with the saving part. I also don't think you can have a checkbox in a listbox.

http://www.baldyweb.com/MultiselectAppend.htm

[Shamli]

Thanks. But my list box has many columns, upon selection the values should append to the table. (with the respective fields)
How to apply that?

This may help with the saving part. I also don't think you can have a checkbox in a listbox.

http://www.baldyweb.com/MultiselectAppend.htm

[pbaldy]

ctl.Column(x, varItem)

where x is the zero-based number of the desired column. In most cases you'd only save a key value from a related table though.

[June7]

Options to save multiple records:

1. execute an SQL INSERT action inside loop that reads each selected item

2. open recordset object then inside loop add new record and after looping completes update the recordset