Loop... Append Query + Open Form + Update Query

[Guest]

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

 

[Damon Heron]

The calculations on the second form are what makes the update, correct? The
user doesn't really have to do anything, and the table rates are updated?
Perhaps you can build an update query to do the task. Without knowing what
fields and calculations are involved
I can't give you specifics, but a query should work.

Damon