Reset the value of a field for all records in continuous form

[kwaldman]

I have a continuous form with about 5 different fields. The user will
input a number in one of the fields (AmtReceived) for each record, but
I want to create a command button that does a couple other things,
then resets the value of AmtReceived to 0 for each record. If I just
use the code AmtReceived.Value = 0, it just resets the value of the
current record to 0.

Is there a way to reset it for all records in the table?

Thanks very much.

[BillCo]

the easiest way for a novice user to do this is to create an update
query that sets the value of all the underlying records to 0 and call
that query with a currentdb.execute statement (to avoid update
warnings) followed by a refresh of the form's recordsource. I won't
flesh out each step - there's enough sample code out there.

....but it very much sounds like you are doing something strange here -
perhaps using the continuous forms inappropriately. what are you
trying to achieve? there may be a more sensible way to go about it.