How populate two field on a form using data entered in 1st field
Posted on 2014-01-19
I have three fields on a form.
Field #1 is a combobox from which a user can select a year. For example, "2013"
Fields #2 and #3 are fields which I want to populate on the afterupdate event of field #1.
If the user selected 2013 from field #1, I want field #2 to populate with "7/1/2013" (It will always be July 1st).
If the user selected 2013 from field #1, I want field #3 to populate with "6/30/2014" (one year after field #2).
How can this be done?