Moving between recordset tables

[grahamw]

Hi All.
I want to perform the same loop on different recordsets (for different calender years) instead of having to repeat the same code.
At present I open up 2002 data- run loop- rec.close
open up 2003 data- run loop- rec.close
and so on.
Can I do a loop through specified recordsets instead of copying and pasting the same code.
Thanks
Graham, London

 

[RuralGuy]

Sure, if the fields are the same. Just create a Function() or Sub() and pass it the RecordSet.