MS Access

I have a form connecting to a table. the table has a “status” field – 0,1,2,3 are the optional statuses. I created a combo box for changing a status and wrote a VB code that does things as the status changes.

very important ! the form shows only records with a staus of 0.

When the code begins it checks if the status is 0. if it is, changes are made and the status changes from 0 to 1.

when I try to change another record’s status the code responds as if the status is 1 and not 0.

I tried to add to the code the methods requery and refresh
(form_name.recordset.requery)
(form_name.recordset.refresh)

but with no success.

what can I do ?

many thanks
Itay