#1
|
|||
|
|||
AutoFill Information
Hello, I am a beginner in this field.
I am trying to do an autofill for some information in the form I am creating I am using Legacy Forms to create my forms Within the form, I have a drop down list bookmark: Company, with the items X and Y as choices. On the field settings, Calculate on exit is selected In another line or section of the document, I have inserted a field to auto input Phone numbers My field code is {IF { Company }="X" "(111)111-1111" {IF {Company}="Y" "(234)567-8910"}}} After protecting the document, for example, selecting "X" from the drop down list doesn't update the field code I wrote for autofill phone numbers when a Company drop down list have been selected Please give help or give me suggestions as what I am doing wrong. Thank You |
#2
|
|||
|
|||
Update: My code works when I update the field with F9 in when unprotected, but I want it to fill in when someone selects an option from the Company drop down and updates the field
|
#3
|
|||
|
|||
Change the properties of your company drop-down to "Calculate on exit."
Re-protect your document. That should have the same effect as the F9 key. |
#4
|
|||
|
|||
Quote:
Note: I upload my document if you want to take a look at it. I have used content control and legacy field, but I plan to switch everything to legacy form when I can get the field codes to update. Thanks! |
#5
|
|||
|
|||
|
#6
|
|||
|
|||
Thanks for the suggestion!
I am currently using a dotx, but I will be saving it as a template once I am done with everything. So for the event handler, I need to code it in VBA to fill the rest of the information? I am have little knowledge on VBA but I will look this up and improve Thanks! |
#7
|
|||
|
|||
.dotx is a template. You will want to change to .dotm.
Yes, you will need an event handler. I cannot supply that right now. Someone else will likely help you with this. There have been a number of questions and answers on this in the VBA Forum. Search for dropdown. |
#8
|
|||
|
|||
Great, Thank You
|
#9
|
|||
|
|||
Macro For ComboBox selection to autofill another Content Control
Hello, I am have very little knowledge in VBA.
I am creating a form for the company I am working for. I am using a content control user forms I have a combo box (Title/Tag : Doctor) After selecting a choice, I want a text content control (Phone) to autofill the information Someone have suggested using a change Event Handler, but I do not know how to do this. If someone can help me with this I appreciate it Thank You |
#10
|
|||
|
|||
Take a look at this thread.
https://www.msofficeforums.com/word-...dent-drop.html and this thread https://www.msofficeforums.com/word-...down-text.html |
#11
|
||||
|
||||
See:
https://www.msofficeforums.com/word-...html#post46903 and, for different elements from a selected item to be output to different content controls, see: https://www.msofficeforums.com/word-...tml#post120392
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#12
|
||||
|
||||
Quote:
Code:
{IF { Company }="X" "(111)111-1111" {IF {Company}="Y" "(234)567-8910"}}} Code:
{IF{REF Company}= "X" "(111)111-1111"}{IF{REF Company}= "Y" "(234)567-8910"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
Looking at your document, for some reason I was unable to apply any editing restriction (including filling in forms) to it.
|
#14
|
||||
|
||||
Since you output all goes in the same table, try the attached, which based on the code in the link I pointed you to above (I have merged your threads).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#15
|
|||
|
|||
This works perfectly, Thank You
|
Tags |
auto fill, auto generate, autofill, content controls, fields word functions, word vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question about autofill | oscarlimerick | Excel | 3 | 01-15-2021 04:12 AM |
Combo Box and AutoFill | samrosen | Word VBA | 5 | 08-03-2016 05:12 AM |
Creating AutoFill form - AutoFill information depending on a selection. | RyanHarper | Word | 3 | 06-15-2015 01:01 PM |
Autofill | Stacybug1 | Excel | 2 | 01-28-2015 01:04 PM |
AutoCorrect Or AutoFill | Johnny thunder | Outlook | 0 | 05-02-2011 03:37 PM |