By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Auto populate

P: 1
I have a form that has 2 date fields. One I enter the date the other I want to auto populate with a date 90 days from then. I've tried various ideas from here but no luck. Need some help...

Thanks!!
Jan 5 '12 #1
Share this Question
Share on Google+
1 Reply


Seth Schrock
Expert 2.5K+
P: 2,951
Assuming that they are text boxes, then in the properties window, data tab, enter the following in the Control Source (top item in the list):

Expand|Select|Wrap|Line Numbers
  1. =[First textbox name] + 90
When you enter the first date, click on the textbox containing the second date and you will get the date 90 days from the date selected in the first textbox. I think that there should be a way to make it update the value without clicking in the field, but I can't come up with anything.
Jan 6 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.