C
chester
Guest
I have a main entry form with the typical buttons (close, add new record, etc).
The sub form is area of main data entry for the user.
In this particular database, my user is inputing account data each month to track phone accounts.
In actuality, the individual accounts are not going to change from month to month except the dollar amount of the bill. So the only field she will need to change is the bill amount (known here as [billamt] ) field. The rest of the record will remain the same (which is nothing more than definitive information that says things like who the vendor is, their location, POC, etc).
She will have a button to "add new record" of course in the event there is a new vendor.
My question is this:
Is there a button I can add to the main form which when the user clicks will set the field "bill amount" back to zero for all of the records in one swoop? I don't want to zap the database clean and wipe out the records, just set that one field to zero so that she starts with a clean slate at the start of the month for that field only. I tried to do it with the "on click" event by using the simple code of: [billamt]=0 but all that happens is the record you're physically sitting on will set to zero. Which defeats the purpose because then the user has to cycle through hundreds of records and clicking this button to set that respective record to zero and is extremely time consuming.
Is there such a code to do what I need?
The sub form is area of main data entry for the user.
In this particular database, my user is inputing account data each month to track phone accounts.
In actuality, the individual accounts are not going to change from month to month except the dollar amount of the bill. So the only field she will need to change is the bill amount (known here as [billamt] ) field. The rest of the record will remain the same (which is nothing more than definitive information that says things like who the vendor is, their location, POC, etc).
She will have a button to "add new record" of course in the event there is a new vendor.
My question is this:
Is there a button I can add to the main form which when the user clicks will set the field "bill amount" back to zero for all of the records in one swoop? I don't want to zap the database clean and wipe out the records, just set that one field to zero so that she starts with a clean slate at the start of the month for that field only. I tried to do it with the "on click" event by using the simple code of: [billamt]=0 but all that happens is the record you're physically sitting on will set to zero. Which defeats the purpose because then the user has to cycle through hundreds of records and clicking this button to set that respective record to zero and is extremely time consuming.
Is there such a code to do what I need?
