Use form list box to create multiple records in table
Posted on 2003-11-21
Hello Experts! This is my first time using this site. I am also new to Access.
Here’s what I am trying to do:
I would like to create a form that contains a multi select list box (or combo box) and a text box. The list box (CustomerNumber) will contain a list of customers and the text box (Comment) will be a comment field. I would like to have the ability to select multiple customers from the list box, enter a comment in the text box, and have a separate record created in my table for each selected customer using the comment entered. For example, if I selected customer1, customer5, and customer7 from the list box and entered “sample comment” into the text field, I would like for the following records to be created in my table:
ID CustomerNumber Comment
1 customer1 sample comment
2 customer5 sample comment
3 customer7 sample comment
I hope that makes sense…
Any advice you can give me will be greatly appreciated (please keep in mind that I have limited knowledge of Access and writing code). Thanks.