Update Data after adding After Update Event
Posted on 2011-02-25
I have added an after update event to a field on a form called [DateofAdmission]. There is existing data in the underlying table. The after update event automatically updates a date in another field on the form called [NextDue]. The After Update event takes the DateofAdmission and addes 30 days to it and updates NextDue. Again, there is existing data in NextDue and it is not accurate (not 30 days from DateofAdmission). How do I get the code to update all the records with the correct NextDue without manually reentering all the DateofAdmission fields. I know this is probably simply, but I am not a programmer. Thanks for your help.