How to set up list box to create new records based on selections

[jmcclow]

I am trying to create a form that has list box controls for months (period), and when selected it takes all of the data currently on the form and copies it for each month selected. This will help speed up data entry, rather than entering the details in the form each time.

In other words, I want the user to fill out the form and then the information is copied for each month selected on the list box.

So if the form contained
Event (text box - user enters - Radio Ad)
Season (text box - user enters - Spring)
Period (list box options - jan, feb, mar, apr, may, june...)

and the user selects mar, apr, may from the list

then it would create the following in the table:

Event Season Period
Radio Ad Spring apr
Radio Ad Spring may
Radio Ad Spring june

I'm working on my first form and I'm on the bottom end of the learning curve on this one. Is this something that a novice can design?

I know how to open a module and copy code and write basic SQL statements, but I don't know all of the form/control setting that need to be set up for this to happen. The form works great, but the multi-select is confusing me. Could someone please provide a step by step explanation of how to set this up. I greatly appreciate any advice.

 

[pbaldy]

Is this what you're looking for?

http://www.baldyweb.com/MultiselectAppend.htm