Re: 1. Autopopulation of date fields based on drop down menu selection; 2. Calculate time span based on selection

Alec Pojidaev — Thu, 30 Jul 2009 14:34:45 GMT

Check this out:

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

1. Autopopulation of date fields based on drop down menu selection; 2. Calculate time span based on selection

anr3216 — Wed, 29 Jul 2009 21:28:42 GMT

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!

Newbie Questions

Re: 1. Autopopulation of date fields based on drop down menu selection; 2. Calculate time span based on selection

1. Autopopulation of date fields based on drop down menu selection; 2. Calculate time span based on selection