Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2019, 10:12 AM
Charles Kenyon Charles Kenyon is offline Multiple IF THEN ELSE form Windows 10 Multiple IF THEN ELSE form Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,474
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I apologize for the confusion. Microsoft has confounded all of us by naming different features/controls the same and using the term "Form" to mean all sorts of different things. It is confusing for all of us.



I would use mapped content controls for your ComboBoxes. See:
Then test a copy of your mapped ComboBox in an IF Field for the condition you want to result in display of your text. Note that IF fields are case-sensitive. Use an AutoText field as your truetext result in the IF field.

The AutoText should be stored in your document template. If the document will be separated from the template, you can lock or unlink that field upon completion of your form.


The reason for using mapped controls is it saves having to bookmark the controls and use a REF fields in your IF field. Also, mapped controls update instantly which is not true of REF fields.


Note that Paul knows far more about fields than just about anyone else. There are several of his tutorials on them pinned to the start of this forum.
Reply With Quote
Reply

Tags
fields, vlookup

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Form Which has Multiple PrePopulated Forms Within rx360 Word VBA 2 12-05-2017 06:45 PM
Multiple IF THEN ELSE form Way to save all attachments form multiple emails at once Joey Cheung Outlook 1 12-06-2014 04:12 AM
Multiple IF THEN ELSE form Multiple Text Fields in Form robstark Word 1 08-11-2014 11:26 AM
make a form that can be used multiple times at once Dsp581 Excel 19 04-05-2013 07:25 AM
Multiple IF THEN ELSE form form a database from multiple sheets udea Excel 1 04-25-2011 02:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:40 AM.


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