Repeat record entry based on option group selection

[rcfreed]

Is there a way to duplicate, triplicate, a record based on an option group selection. i.e.

Form
Field: Option group
Value = 1
Value = 2
Value = 3
Field 2:
Field 3:
Field 4:
and so on.

Basically if value 1 is selected, then I fill out the rest of the fields hit enter and go to a new record. But if value 2 or 3 is selected, I fill out the the fields, hit enter. The information is recorded said number of times based on the selection in the option group. Ideally I would have2 or 3 of the same record in the db, with different Primary keys of course.

 

[llkhoutx]

Execute an append query with VBA, adding the current record the appropriate number of times.

 

[rcfreed]

I'm sorry, i should have specified that i'm pretty new to Access. What you said just lost me? Would you be able to dumb your explanation down?

 

[llkhoutx]

What I said is about as basic as it can be.