Transpose from list box to several fields in Table

[Monfas]

Hi,

I am improving a database to be used in humanitarian operations in South Sudan. I am trying to do the following:

I have a list box that is populated selection. This list can have up to 14 items. I also have a table with a field for up to 14 items.

What I want to do, is to populate the 14 fields of the table, with the values from the list box in the form.

I don't know much of VBA, so I have no idea how feasible is this. I am trying to transpose the list box and then populate the table, however I've not been able to do it.

Thanks,

[ADezii]

What you are requesting can be done, but it is a rather strange Request. May I inquire as to what your logic is?