I've got a form that upon selecting a a record from a combo box, the data for
that record is copied to a temp table that is used for a different form (to
update the data).  This 2nd form is an edit form for users to update data on
the selected record.  When this form opens, a number of calculations are made
to update various rates in the data.  A bunch of my records have incorrect
rates, and if I select them and open the 2nd form the errors are corrected.  
I've got almost 8000 records and was wondering if there was a way to make a
loop to :

1. copy the first record to the temp table
2. open the 2nd form (based on the data in the temp table)
3. close the form
4. update the data in the original table
5. loop to next record
6. continue until the end of the table is reached.

The main table and the temp table have the same records.

Please help.

-Matt