Insert multiple records from form
I have a form where I would like the user to be able to click on a command button to insert multiple records based on criteria they have selected in a few list boxes and text boxes. I have the form set up, but am not sure how to code the VBA for the insert. It would work like this: insert one record onto a table for each item they have selected in one of the list boxes (a multi-select list box). If they select 5 items, VBA will insert 5 rows onto the table. Also will use the other data they have entered as well from the text boxes.
Can anyone help me write this code, or at least point me in the direction on how to find out how to insert multiple rows via VBA?
Thanks in advance,