I am very much a novice with InfoPath, VBA, SQL, etc. I have a Contract Management form for which I would like to do the following:
1. Autopopulate date fields based on drop down menu selection
a. Drop Down menu consists of frequency options: Monthly, Bimonthly, Semiannually and Annually
b. I would like to autopopulate date fields based on the selection from the drop down menu
2. Calculate time span based on drop down menu selection
a. I have a START date field and an EXPIRATION date field
b. I would like the drop down menu selection to calculate the time span between these two fields, and autopopulate the correct number of date fields (question #1 above)
For example, if the contract starts October 1, 2009 and expires March 31, 2010, I want six date fields to autopopulate when I select the Monthly drop down menu item. Is this possible? Am I in over my head?
Thanks in advance for any guidance!