Update Query with serialized Field

Hello -

I am trying to execute an update query, updating 4 fields in one table.
Is there a way that I can enter the first value for each field, and
then serialize the first field for a given qty, while duplication the
other 4? I want to avoid having to enter every single record manually.

Example:

Serial Batch Part Tech
123 500 A1 ABC
124 500 A1 ABC
125 500 A1 ABC


Thanks!

re: Update Query with serialized Field

the way I usually handle this is to create an unbound form and then
write some code to loop from StartSerial to EndSerial and then just use
a recordset to fill the table.

for lngSerial = val(me.controls("StartingSerialNo")) to
val(me.controls("EndingSerialNo"))
rs.AddNew
rs.Fields("Serial")=lngSerial
rs.Fields("Batch")=me.Controls("txtBatch")
rs.Fields("Part")=me.Controls("txtPart")
rs.Fields("Tech")=Me.Controls("txtTech")
rs.Update
next lngSerial