Insert Rec into table based on user selection from a list

[BrothersKeeper]

If user makes multiple selection from a list, I'd like to be able to insert a record into a table for each selection. I'm close where it's inserting a record for each selection but there's no value in the field, they're blank.

 

[GingerR]

Please post your code, the row source of your list box, and table structure.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[PHV]

Or simply have a look to ItemsSelected in the VBA help.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886