Multiply entries from one form submission

[Mr Anderson]

Hi guys, I'm new to Access and i'm hoping you can help with a problem. Each year a club im part of hold a raffle which can be quite a task so i volunteered to build something in Access to allocate ticket numbers and collect name, address etc. The building of the form im ok with but the table is causing me an issue as i want the option to purchase multiple tickets. so far purchasing a single ticket is ok but when a quantity of more than one is entered the autonumber will give a ticket number of the last in sequence i.e if 5 tickets are selected it gives me a ticket number of 5 but i need it to show five entries with ticket numbers 1,2,3,4,5.
I hope this makes sense. If you can offer any help i would be very grateful

[ranman256]

you can either enter 5 records,
or
build a loop that uses the txtQty entry and does it for you

sub btnAdd_Click()
dim i as integer

for i = 1 to txtQty
   docmd.openquery "qaAdd1Ticket"
next
end sub

[RuralGuy]

I would suggest NOT using an AutoNumber but build your own: http://www.baldyweb.com/CustomAutonumber.htm

[Mr Anderson]

you can either enter 5 records,
or
build a loop that uses the txtQty entry and does it for you

sub btnAdd_Click()
dim i as integer

for i = 1 to txtQty
   docmd.openquery "qaAdd1Ticket"
next
end sub

Sorry this is all new to me, where can i input the code ?

[RuralGuy]

How are you currently adding a new record?

[Mr Anderson]

Adding new records through a basic form. Oh and thanks your patience I’m sure dealing with someone who doesn’t know what they are doing is frustrating

[RuralGuy]

How do you want the "new" numbers to be read out?

[Mr Anderson]

They don’t necessarily need to be shown on the form once the entry has been made. What I am trying to collect is an email address, first name & surname this then gets assigned a number (my range will be 1-1000) then once finished be able to pull some basic reports for the purpose of the draw

[RuralGuy]

So what you are probably going to want is a button on your form that will duplicate the last entry n times, right?

[Mr Anderson]

Yeah possibly, to be honest I’m not sure what the best option is. I thought this would be quite simple, that was my first mistake

[RuralGuy]

Welcome to the wonderful world of programming. Will anyone be running this system or just you?

[Mr Anderson]

Just me if I can get my head round it in time

[RuralGuy]

If you can see more than on record at a time, like in datasheet or continuous view, you can use windows copy and paste keys when adding the new records. I'm trying for suggestions that don't involve code if possible.