Multi select Listbox needed to populate a table field

[manrique83]

I couldn't find a concrete answer to my question in any of the other threads.

I have a listbox that is supposed to populate a field in my database after the user has selected a choice. It works fine if the multiselect is set to 'None' but I needed to be Simple or Extended. If i do that, when the user clicks on multiple values, the corresponding field in the table wont be updated.

I assume I need code to do this but I wouldn't have an idea as to how to write it.

My form has other textboxes and combo boxes that are updating one table after the user tabs until it has reached the end and a new empty form begins. The textboxes and combo boxes update fine, but my listbox doesn't.

Any help?

 

[PHV]

Have a look at the ItemsSelected property of the ListBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gol4]

If it has multiselect set then it no longer has a value and you would need to use code to go thru the items selected index to see what is selected in the listbox.

In a propery designed database each field holds 1 value so if the listbox is bound to a field there should be no need to have any more the one selection.

 

[manrique83]

Thanks guys,

I took a look at the ItemsSelected property and I knew of its properties. My problem is that I am fairly new to VBA and I wouldn't know how to store the selected items in my table field.

And yes, I need it to be multiselect because the entry can be 1 or various options.

Can you guys help.

 

[PHV]

because the entry can be 1 or various options
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886