Combo boxes that generate separate table entries

[guamlet]

I have a form that users can select a product name and an action (shipped, lost, returned, etc). Currently, if they do the same action to several different products, they have to go through the form for each product. I would like them to be able to select multiple products from a list and assign one action to all of them. Then access would create new entries in the table for each product. Any suggestions?

 

[Russell Hauf]

Make the list box multi-select, then do the action for each item selected (in VBA).

HTH,

Russell