Rabu, 21 September 2011

[MS_AccessPros] Update calculated fields when form, opens

 

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

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar