change value of field on all records when form opens

[robsworld78]

Hi, I have a form with a subform, one of the fields on the subform already has data in it when I open this form however when I open this form I want that field to change to 0 from whatever it currently is on all records.



The subform is set as continuous form and in the on load event I put
Me.BarsReturned = 0
that works but it only changes the first record in the subform, I want it to change all records to 0.

Wherever I put Me.BarsReturned = 0 it will only change the first record.

[robsworld78]

how do you delete a thread, I dont need an answer, this won't work