Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2017, 04:41 PM
macropod's Avatar
macropod macropod is offline Form with conditional field. Windows 7 64bit Form with conditional field. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Without seeing your existing document, it's impossible to know what the best way would be to address the issue. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-18-2017, 07:48 AM
Asuryan33 Asuryan33 is offline Form with conditional field. Windows 10 Form with conditional field. Office 2016
Novice
Form with conditional field.
 
Join Date: Oct 2017
Posts: 9
Asuryan33 is on a distinguished road
Default

Actually, I don't have documents yet.

But, basically.

1) I need a first set of option that will populate the "To:" field of the email.

-Local office
---City1
---City2
---City3
---Etc.
-Central office

2)I need a second set of option that will determinate wich options will be availlable after
-Child
-Adult.

3) I need a dependant (from 2) set of options that will determine wich field to show. Also, the chosen option will populate the first part of the Object of the email.

4) finally, the text fields.
-for option 1)
---First Name
--- Last Name
---File Number:
---DOB:
---Address
--- etc.

-For option 2)
---First Name
--- Last Name
---File Number:
---DOB:
---Name of reference
---Addresse of reference
---Etc

I should have 30 differents options with common field inside, to identify the client and populate the "object". Others options are to send the information by mail to other office. I know it will be way easier to use a database but ... anyway ..
Reply With Quote
  #3  
Old 10-18-2017, 12:52 PM
macropod's Avatar
macropod macropod is offline Form with conditional field. Windows 7 64bit Form with conditional field. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

The first item can be accomplished with a simple dropdown, as can the second, but I have no idea what you mean by "that will determinate wich options will be availlable after", or what the third item is supposed to be. Items 4(1) & (2) appear to be essentially the same, except for 'Name of reference' in (2).

As for:
Quote:
Originally Posted by Asuryan33 View Post
I should have 30 differents options with common field inside, to identify the client and populate the "object". Others options are to send the information by mail to other office.
I think you're getting well into the kind of project for which you should be hiring a forms designer/programmer instead of expecting volunteers on forums like this to develop something so complex for you.

You should also consider whether you should use a small number of relatively simple templates instead of trying to shoehorn everything into one complex one that will be much harder for anyone at your end to maintain/update.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 10-18-2017, 01:21 PM
Asuryan33 Asuryan33 is offline Form with conditional field. Windows 10 Form with conditional field. Office 2016
Novice
Form with conditional field.
 
Join Date: Oct 2017
Posts: 9
Asuryan33 is on a distinguished road
Default

I understand.

Finally, my question is how to make conditional field.

If value of field 1 is B then show field 1,2,3,20,98.
Reply With Quote
Reply

Tags
conditional form, form, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form with conditional field. Macro to autofill a form field ONLY if the form field is blank upon entry Pindar Word VBA 2 01-12-2017 05:03 PM
Form with conditional field. Conditional Field CKTisdale Word 1 04-10-2015 02:41 PM
Conditional formatting in custom field Puddlerunna Project 6 11-05-2014 06:14 AM
Form with conditional field. Form field selection allows entry into form text box David C Word 1 10-24-2012 04:53 AM
Form with conditional field. Form Fields - Create blank form text field with if statement? LAssist2011 Word 5 12-14-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 PM.


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