Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

Update Data after adding After Update Event

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.    
0
manndo
Asked:
manndo
1 Solution
 
Rey Obrero (Capricorn1)Commented:
run an update query, backup your table first

update tablex
set NextDue=dateadd("d",30,[DateofAdmission])
0
 
manndoAuthor Commented:
Worked like a charm.  Thanks again capicorn1.  You are awesome.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now