Creating multiple New records of releated data from one single Entry

[Hendro623]

I'm looking to create a database that would generate labels to be scanned and used to track our inventory. Each label needs a unique ID that cant be duplicated. I imagine a form where a user would enter their Item, Lot, quantity, etc. followed by how many labels needed. The number of labels would be the number of records that are created and all contain the same data, minus unique ID that would be scanned. It seems like this is possible but I have no idea where to start.
I've built a similar concept in excel where I auto filled some fields based on entries, then used the =NOW() formula down to the second but in number format, which was entered into a template as the ID. I then made a similar template in the same worksheet, but changed only the formula to add another second from the 1st ID(date), making it unique. I then copied that one over 100 times where each unique ID always reflected the previous... if that makes sense. Each template is sized as 1 page, only thing is that the user has to specify how many pages otherwise it prints the entire workbook. Its usable, but I'd like the ability to do something like that in access. Anyone have an idea on how to throw something like that together?

[CJ_London]

something like the following in a 'create labels' button click event

dim I as integer
dim lastID as integer
lastID=dmax("LabelID","tblLabels")
for I=1 to me.labelsneeded
    currentdb.execute("INSERT INTO tblLabels (Item, Lot, quantity, LabelID) Values(" & me.item & ", " & me.lot & ", " & me.quantity & ", " & LastID+I & ")")
next I

Alternatively for LabelID, make it an autonumber field, in which case you don't need to insert it