Solved Number inceament based on other table value

[Pat Hartman]

Open TWO recordsets rsIN and rsOUT
Read the rsIN as you are doing but inside the loop, instead of running a query, use

rsOut.AddNew
rsOut.Fld1 = Me.fld1
rsOut.Fld2 = Me.fld2
rsOut.Fld3 = Me.fld3
rsOut.Update

 

[john_gringo]

Open TWO recordsets rsIN and rsOUT
Read the rsIN as you are doing but inside the loop, instead of running a query, use

rsOut.AddNew
rsOut.Fld1 = Me.fld1
rsOut.Fld2 = Me.fld2
rsOut.Fld3 = Me.fld3
rsOut.Update

Yeap!!!
I follow your instructions.
Rst.Edit
Rst!Mark = Mark
Rst.Update
As MARK is included in the first recordset.

Thank you for your kind support.

 

[Pat Hartman]

You're welcome