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
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