Need help with moving through records

  • Thread starter Thread starter Jack Peyton
  • Start date Start date
J

Jack Peyton

I use Access 2000. Need help with moving through records. I have a main
form ”FMonPayPark” which has two continuous subforms. Using a command
button which is on each record in the first subform-“FMonPayParkC”, I run a
query that appends records in the second subform-“FmonPayParkB”. I would
like to do this automatically rather then clicking the command button on
each record. Something like this:

Start at first record of “FMonPayParkC”
Run append query to update records in “FMonPayParkB”
Move to next record in “FMonPayParkC”
Run append query to update records in “FMonPayParkB”
Continue doing this through the end of the records in “FMonPayParkC”

Any help or direction will be appreciated.
Jack Peyton
 
You can probably do that a few ways.

You can create a few update queries and drop them in a macro, and run
the macro when you press the button.

Or you can "manually" open each table, edit/add/whatever to each record
and step through the table and repeat the process. Something like:

dim db as database
dim rec as recordset

set db = currentdb
set rec = db.openrecordset ("TableA")

do while rec.eof = false
'Do whatever to the data
rec.movenext
loop
 
ManningFan
Thanks for taking the time to look at this. I will try out these ideas.
Jack Peyton
 
Back
Top