Updating table via query (via a form!)

[Pharcyde]

Afternoon all

My tblStudentToAssessments has Yes/No fields [Resit] and [ResitPaid]

i have a query qryResitsUnpaid which basically brings up all resits, unpaid - funnily enough!
When the [ResitPaid] box is checked (in tblStudentToAssessments), the data is picked up by qryResitPaid instead.
This all works fine and is cool.

Still with me?


For convenience' sake I'd like to be able to update the checkbox on the form frmResitsUnpaid (based on qryResitsUnpaid) so that the query will update tblStudentsToAssessments...

Can I do this? If so how? Seems I cant get my head around it this morning.

Thatnks in advance, LeeBoy