FindFirst

[dhstein]

I have an inner loop which does findfirst/ findnext for table 2 within an
outer loop which is processing records in table 1. I can either A) open
table2 - do the finds - close table2 - within the inner loop or B) open
table2 outside the inner loop and close it outside the inner loop. So the
question is - does findfirst always reset the pointer back to the beginning
of the table? Thanks for any help you can provide.

 

[Arvin Meyer [MVP]]

I have an inner loop which does findfirst/ findnext for table 2 within an
outer loop which is processing records in table 1. I can either A) open
table2 - do the finds - close table2 - within the inner loop or B) open
table2 outside the inner loop and close it outside the inner loop. So the
question is - does findfirst always reset the pointer back to the
beginning
of the table? Thanks for any help you can provide.

Since I have never seen code used with FindFirst that forces a
rst.MoveFirst, I would guess yes.