Avatar of StampIT
StampIT
Flag for United States of America asked on

Use after update to change dates

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.
Microsoft Access

Avatar of undefined
Last Comment
StampIT

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rey Obrero (Capricorn1)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
StampIT

ASKER
Works perfectly. Thanks.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23