troubleshooting Question

Use after update to change dates

Avatar of StampIT
StampITFlag for United States of America asked on
Microsoft Access
2 Comments1 Solution92 ViewsLast Modified:
In an Access form there are two text boxes(StDate, EndDate) that represent a date range. The default property is set at Date()-1 for StDate and Date() for EndDate. There are two more text boxes(StDate2, EndDate2) that are also a date range. StDate2 and EndDate2 are dependent on StDate and EndDate. All of these can be initially set in the text box porperties. However if the user changes the StDate I would like to use the After Update event to change the second date range accordingly. What code would be necessary to accomplish this ? StDate2 and EndDate2 are 1 day less than stDate and EndDate.  Thanks.
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros