In this warranty database I'm cobbling together I have a field for Warranty Days Left. When a record is added that field is calculated on an AfterUpdate event of another field using WarrantyExpiryDate-Date.
Obviously all the expiry days left need to update each day, when a user opens the form, and the new values (normally 1 day less!) stored in the table to replace the existing.
BUT...I don't know how to do this!
Can someone please help with a description of how to do this update when the form loads, and/or some code. I'd rather do the update automatically, but if I have to put code behind an 'Update' button that'll be fine.
Thanks, Nige
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar