Entering one item to create multiple entries

[MCCDOM]

Hi all,



I am a little bit stumped on how to do this so would really appreciate some help.

Basically I am inputting stock into my database so I can have a record of what I have left and who it's gone too. Where I'm stuck though is when I want to add an item that I have more than one off but only enter it once and have it assigned a unique stock ID number (this is in the form of an autonumber) for however much quantity I choose to enter. So for example I have 5 keyboards, I type in 'Keyboard' into my item field (named txtItem) and then type '5' into my quantity field (named txtQuantity). When I then press Add Stock (named btnAddStock) I should then see in the table, 5 separate Keyboards listed each with a different Stock ID number.

Hopefully I've explained this enough but any questions please don't hesitate to ask.

Look forward to your replies

Thanks

Dom

[ranman256]

In a form, enter the item, and Qty, say:
txtItem
txtQty

Build an append query that adds the 1 item, then the button click will run a loop

sub button_click()
dim i as integer

docmd.setwarnings false

for i = 1 to txtqty
   docmd.openquery "qaAddItem"
next

docmd.setwarnings true
end sub

[MCCDOM]

Thank you for your quick reply.

I will try and put this into practice and get back to you with the result.

Thanks again

[MCCDOM]

Hi Ranman256,

I tried what you've suggested and created a 'Append Query' for the add item, not sure if I did it right though (see attached photo of the query) as it does create multiple copies in the stock table but unfortunately it is just making copies of what was already in the table (see attached stock table photo). Could you let me know what might of gone wrong or i'm not doing correctly.

Many thanks