Duplicate a forms data for each item in a list box

[lynxbci]

Hi,

Trying to be a simple as possible.

I have a form (frm_Promo) that has 20+ fields on it, sourced from a table.
There is also an listbox (Lst_promonames) on the form sourced from another table

The user adds new record fills out the frm_Promo with all the details, and then selects one or more of the items in the lst_promonames.

What i then want to do is to duplicate the record entry for each item selected in the list box, so if they chose 4 'names' in the list box, it would duplicate the new record four times.

I hope that makes sense. Thank you in adavnce

 

[Ranman256]

The EASY way, is to use Dbl-Click only, not multi-pick.
The user dbl-clicks an item in the list, this executes an append query.
The query uses the items on the form,and listbox, and adds them to the data table.
Then user picks another item,and dbl-clicks again. 1 query,no code.

If you use multi-pick list,then you must create code. And if you don't know how, it's a headache.

I say use the zero code method.