Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-21-2013, 11:15 PM
macropod's Avatar
macropod macropod is offline Form auto fill based on a different field value. Windows 7 64bit Form auto fill based on a different field value. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,536
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi stct,

See attached. The document uses a dropdown formfield for the predefined values, and formula fields for the variable output. If you unprotect the document and press Alt-F9, you'll be able to see the formula field contents. Note that you must exit the formfield (via the TAB key) after updating it for the conditional output to appear.
Attached Files
File Type: doc Formfields - DropDownDemo.doc (33.5 KB, 681 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 AM
Form auto fill based on a different field value. Nested if field that contains a fill-in field is not prompting for fill-in info Nccadm Mail Merge 2 04-02-2013 03:15 AM
Form file timesheet, auto fill date from calander jkeeney Word 1 03-21-2012 12:21 AM
Macro to populate a text form field based on dropdown selection koloa Word 0 10-20-2011 11:52 AM
Form auto fill based on a different field value. How can I fill in form I received in email that used underlines instead of text field Gail L. Word 2 05-17-2009 12:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2026 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft