Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2012, 03:59 PM
Charles Kenyon Charles Kenyon is offline Drop Down Form Help Windows Vista Drop Down Form Help Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
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

Instead of formfields, use IF fields testing on the results of your first field. You must name your first field for this to work and have "calculate on exit" checked in the properties.
Reply With Quote
  #2  
Old 07-31-2012, 06:39 PM
jwm1346 jwm1346 is offline Drop Down Form Help Mac OS X Drop Down Form Help Office 2012
Novice
Drop Down Form Help
 
Join Date: Nov 2011
Posts: 8
jwm1346 is on a distinguished road
Default

Thanks for the response!

I am having some difficulties with this. I set up a simple example with options 1 2 and 3 in the drop down box. It doesn't seem to change when the value in the pull down box is changed. Can you please verify my IF info is correct? In the below example my drop down box is called Test.

{ IF "Test" = "1" "True" "False" }

Can you please advise as to what I'm doing wrong? Thanks!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Form Action launches wrong form RMNZ Outlook 3 03-07-2012 11:26 AM
Drop Down Form Help Form Fields - Create blank form text field with if statement? LAssist2011 Word 5 12-14-2011 03:02 PM
25 item max in drop down form sonicvalley Word 0 07-26-2010 11:12 PM
Drop Down Form Help Form Field - Drop down selection causing auto text chesspupil Word VBA 7 05-09-2010 05:43 AM
form to form data transfer fantomegl Word VBA 0 05-30-2009 10:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:14 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