Populate two date fields base on selection in combobox field
Posted on 2014-01-26
I have three fields on a form.
Field #1 is a combobox from which a user can select a year. For example, "2014"
Fields #2 and #3 are fields which I want to populate on the afterupdate event of field #1.
If the user selected 2014 from field #1, I want field #2 to populate with "7/1/2013" (It will always be July 1st).
If the user selected 2014 from field #1, I want field #3 to populate with "6/30/2014" (one year after field #2).
How can this be done? (This is similar to a question answered previously by an expert but the combobox selection is different)