Update Query with serialized Field

[jlkass@gmail.com]

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!

[pietlinden@hotmail.com]

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 ("StartingSeria lNo")) to
val(me.controls ("EndingSerialN o"))
rs.AddNew
rs.Fields("Seri al")=lngSeria l
rs.Fields("Batc h")=me.Controls ("txtBatch")
rs.Fields("Part ")=me.Controls( "txtPart")
rs.Fields("Tech ")=Me.Controls( "txtTech")
rs.Update
next lngSerial