Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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