View Single Post
 
Old 12-01-2015, 10:18 AM
rlmoss44 rlmoss44 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Dec 2015
Posts: 4
rlmoss44 is on a distinguished road
Default Automatic Form update

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
Reply With Quote