Good morning, Im green to all the VBA/Marco in word, I work with AF cadets and Im trying to get this form to auto populate based on class year see example below

1. RANK: cadet
2. DATE OF PROJECTED GRADUATION: June 2016
3. TOTAL ACTIVE FEDERAL MILITARY SERVICE DATE:
4. DATE OF RANK:
5. DATE OF oath:
6. PAY DATE:

I created a drop down for #2 for the class years (June 2016, June 2017, June 2018.....)
I want to be able to auto populate #3, #4, #5, #6, with a specific date based on the selection of class year (#2)
so when I select June 2017 from #2 dropdown menu then #3,4,5,6 all reflects 27 June 2013



please help out a Air Force E7 and about 4000 future officers!!!

I have no idea where to start

Please don't hijack existing threads for different topics.

Please also provide details of what kind of dropdown you're using - a formfield dropdown or a content control dropdown.

You also need to give detailed specifications of what the dropdown possibilities are and how these relate to your required outputs. A single example, such as you've given, wouldn't even warrant a dropdown - one could just type the year.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

My apologies,

What I'm trying to do is make a selection in the dropdown box (Projected Graduation) that will auto populate text (In-processing dates) in C, D, E, and F (on doc)

June 2016 from dropdown should auto-pop 28 June 2012 in C, D, E, and F (on document)
June 2017 = 27 June 2013
June 2018 = 26 June 2014
June 2019 = 25 June 2015
June 2020 = 23 June 2016

Please see attachment*

I created a content control dropdown with the display names & values of June 2016, June 2017, June 2018, June 2019 for the Projected Graduation date. At first I created text fields for C, D, E, and F and was going to try to map it to the content control dropdown. If this type of setup is the wrong way to go about it please let me know, thanks in advance

Attached Files

USAFA Proof Of Service Letter.docx (105.8 KB, 16 views)

Presumably there is some relationship between the input years and the dates from 4 years earlier. I doubt, though, that you'd want to be hard-coding the dates for every few years. If you can say what that relationship is, it should be possible to code the form to output the dates regardless of what the input year is. As for the input year, is it always a June date? If not, you need to provide the logic for how the months relate to C, D, E & F.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

AF Academy cadets are in-processed every year on the 4th Thursday in June...which correlates to C, D, E, F .....they are in college so they are here four years...they graduate the 1st Monday in June (4 years later), that's why the Projected Graduation can be June /year

so by selecting June 2016 (when they graduate) from dropdown... C, D, E, and F should auto-pop 28 June 2012 which was the day they in-processed 4 years prior

selecting June 2017 (future graduation date) from dropdown... C, D, E, and F should auto-pop 27 June 2013 which was the day they in-processed 4 years prior on the 4th Thursday in June .....and keep going from there

See attached. Instead of content controls, I've used formfields, which means the calculations can be done without the need for macros. To see the field coding, unprotect the form and press Alt-F9. The field coding is derived from my Microsoft Word Date Calculation Tutorial, available at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party

Attached Files

USAFA Proof Of Service Letter.docx (99.4 KB, 21 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks you are a life saver, I thank you and my technicians thank you!!