lets say i have 650 records total but i have 40 that needs to be confimed today.
Can you perform a find that pulls up only those 40? (What tells you that these 40 are the 40 that need to be confirmed today?)
That said, OnRecordLoad is a script trigger that will be tripped each time you change the focus to the next record. It could be used to perform a script with Get ( RecordNumber ) to determine that you are on record 40 in your found set.
and hit a button called confirm that sends the record to another table i use for spreadsheets and reports.
I't very possible that you do not need to "send the records to another table". You could easiily generate your reports and table views of this data while keeping it in the same table. A status field can identifies whether or not the record has been confirmed and your other layouts can perform finds that specify only confirmed records to omit records not yet confirmed.