I have created a form on which I have two textboxes with a Date format (mm/dd/yyyy)
Text1 will be used to store a specific date
Text2 should automatically add 1 month to the previous date
I have used the following code to the Default Value property of Text2 but after entering the date in TEXT1, TEXT2 does not update. Thank you for your help.
Text1 will be used to store a specific date
Text2 should automatically add 1 month to the previous date
I have used the following code to the Default Value property of Text2 but after entering the date in TEXT1, TEXT2 does not update. Thank you for your help.
Code:
=DateAdd("m",1,[TEXT1])