Recordset Looping

[Cobra17]

I'm trying to loop through a table records and fields. The field loops work fine, but I can't get it to move down to the next "tbl" record..


i'm using 3 record sets all based on the same table
tbl = the set I want to loop through
rst1 = loops through table field names and compares against rst2
rst2 = loops through table field names

Please Login or Register  to view this content.

I was thinking that maybe an SQL statement would work with to copy and paste if ID_Vessel = OldVesID AND Est_ID - OldEst... but i'm not sure how i could replace only the copied ID_Vessel & Est_ID with NewVesID & NewEst. or maybe some other nice and easy way.

[rorya]

Why are you closing rst1 before you move to the next record?

[Cobra17]

rst1 is used to check field names against rst2 field names...

if the field names match, then it put the value from rst2 into rst1. Not sure where I would put move to next record, that's why 'tbl' is used, to see if ID_Vessel and Est_ID match my criteria... then it runs rst1 & rst2



This code works for going across field names because of the "for each"

Please Login or Register  to view this content.

[rorya]

I think you missed my point. Your code processes the first record in tbl but then closes rst1 before moving onto the next record in tbl. That makes no sense.

[Cobra17]

where should it go?

[rorya]

After you finish with tbl I would assume.