Newb VBA coding help cmd button that copies records

[illicited]

OK I'm new to VBA so I need some guidance on how to code this.

What I got is a continuous subform with a query as its source with about 4 or 5 fields and usually about 6 or so records. I need a command button that reads in the values of a multiselect box that represents one of those fields (extended so multiple values can be selected) as variant or whatever and for each value of the multiselect box copy all the data in the subforms recordset (4 to 5 fields and 6 or so records) into the same table the query is pulling from under each new multiselect value. Basically I have records that I need to copy into the same table but one field needs to change representing a new location for all these items.



Sorry if the description of the problem is bad, I can provide screens or the db if necessary.

Thanks,

[June7]

Multi-select box means a multi-value field. Makes it really, really hard to accomplish what you want. Review http://msdn.microsoft.com/en-us/library/bb258183.aspx

I NEVER use multi-value fields.

[illicited]

I didn't intend on using a multi-value field, but maybe there is a different way to do this. All fields contain one value, I need to copy all of the fields other than plant and change plant to 2, then to 3, then to 4, etc based on all the values selected from the multiselect textbox. See picture of the query.

[June7]

So users could select plants 2, 5, 7, etc and you want a set of records for each. I would use unbound multi-select listbox in header section of a Continuous form, code would loop through the listbox and if row selected, run an INSERT SELECT sql action.