Modules & VBA :: Read Through Recordset And Check For A Condition

Heres what I need to do.

--> open a recordset

--> read through the records

--> check to see if two fields matches e.g (qty=qty_completed)

--> if all records in recordset meets the above condition then run update statement

I want to put this code inside Form_Close. The code that I'm using checks the two fields for the condition and runs the update statement if condition is met. Problem is this a continuous form and I want all records need to meet the condition before it execute update statement.

Using Access 2010 btw.