Select all records in a continuous form

[muppetmad]

I have a continuous form that opens all of the records for a specific user on a specific date and displays them in a continuous form. Each record requires an approval check box be marked before it can be processed for reporting. I want the approver to be able to click a button and mark all of the records displayed at one time. Currently my button will only mark the current record. How to I select all of the records?

 

[MStef]

Look at "DemoApprovalAllA2000.mdb".

 

[muppetmad]

I tried this but it updates all the records in the database. I only want the approver to update the records that have been queried and displayed in the form.

 

[MStef]

Ok, here it is a new mdb, maybe you have to adapt something.