Listbox not writing to table

[Guest]

I've used the wizard to create a listbox and selected the table.column where
to write the selection. It works fine till I change it to a
multi-select/simple then it doesn't work.

How can I do a multiselect and write the values to the datafield?

 

[Guest]

That is not going to work. You can't have multipe values in one field.

 

[Guest]

Any suggestions? I'm working on a Safety log and need to be able to select
multiple Officer names via a list box. Then store the choices in a row with
other items (dates,times, incident codes etc)

 

[Guest]

Without knowing all the details, I can not give a perfect answer, but it
appears you have a situation where multiple officers may be involved in a
single incident and all officers involved have to be referenced in that
incident. If that is the case, then you need a child table to your incident
table to contain the officers involved and any information specific to that
officer. Then, you should have a sub form with that table or a query based