Reply
 
Thread Tools Display Modes
  #1   Report Post  
jrwaguespack
 
Posts: n/a
Default Having multiple form fields automatically updated

I have created a document that has two different text form fields on the
first page. Within the shaded portion of the field, I typed a word so the
user knows what to type in the field. I then saved this document and
distributed it. Each user opens the document and enters the relevant
information in each field and saves the document. Each document is saved
with a different name. The same two text form fields are on the last page of
the document as well (with the same word typed in the shaded area as a
reference for the user). My question is how can I get the informatiion
entered into the two form fields on the first page to automatically be placed
in the two form fields on the last page? I have tried the REF fields, but it
only updates the REF field with the information that I already have typed
into the shaded area as reference information for the user. Any help would
be greatly appreciated.
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

You need to note the form field bookmark name that you wish to reproduce
then use a REF field to call this bookmark and to insert the duplicated
data. Check the 'calculate on exit' property of the form field so that the
REF field is updated with the inserted data.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jrwaguespack wrote:
I have created a document that has two different text form fields on
the first page. Within the shaded portion of the field, I typed a
word so the user knows what to type in the field. I then saved this
document and distributed it. Each user opens the document and enters
the relevant information in each field and saves the document. Each
document is saved with a different name. The same two text form
fields are on the last page of the document as well (with the same
word typed in the shaded area as a reference for the user). My
question is how can I get the informatiion entered into the two form
fields on the first page to automatically be placed in the two form
fields on the last page? I have tried the REF fields, but it only
updates the REF field with the information that I already have typed
into the shaded area as reference information for the user. Any help
would be greatly appreciated.



  #3   Report Post  
jrwaguespack
 
Posts: n/a
Default

I found the name of the form field bookmark (Text5). I checked the
'calculate on exit' property of the form field (the information that I had
typed in the shaded part of the text form field disappears). I then created
the REF field (Control+F9) on the second page. I then typed in REF and the
form field bookmark name within the brackets ( {REF Text5} ). Then I saved
the document. When I opened it back up, there was nothing on the second
page. I also tried to type something into the text form field on the first
page and nothing happened with the REF field on the second page. Any more
advice?
"Graham Mayor" wrote:

You need to note the form field bookmark name that you wish to reproduce
then use a REF field to call this bookmark and to insert the duplicated
data. Check the 'calculate on exit' property of the form field so that the
REF field is updated with the inserted data.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jrwaguespack wrote:
I have created a document that has two different text form fields on
the first page. Within the shaded portion of the field, I typed a
word so the user knows what to type in the field. I then saved this
document and distributed it. Each user opens the document and enters
the relevant information in each field and saves the document. Each
document is saved with a different name. The same two text form
fields are on the last page of the document as well (with the same
word typed in the shaded area as a reference for the user). My
question is how can I get the informatiion entered into the two form
fields on the first page to automatically be placed in the two form
fields on the last page? I have tried the REF fields, but it only
updates the REF field with the information that I already have typed
into the shaded area as reference information for the user. Any help
would be greatly appreciated.




  #4   Report Post  
Graham Mayor
 
Posts: n/a
Default

Did you lock the form?

When you tab out of the field (Text5) the calculate on exit property of that
field causes the REF field to update (unless the REF field is in a text box
or the page header, when you will need an update macro run on exit from the
Text5 field to force the update - you'll find the code for that at
http://www.gmayor.com/installing_macro.htm

If you want to advise users how to fill the fields, then you should Add Help
Text via the button at the bottom of the field properties dialog. This puts
messages on the Word status bar. You can draw attention to these with a
macro which you can either run from an autonew or autoopen macro or a macro
run on entry to field text5. The code for that would be something like:

Sub PopUpAdvice()
Set Balloon = Assistant.NewBalloon
With Balloon
.Text = "Refer to status line at bottom of screen for field entry
details"
.Button = msoButtonSetOK
.Animation = msoAnimationBeginSpeaking
.Show
End With
End Sub

or even

Sub PopUpAdvice()
MsgBox "Refer to status line at bottom of screen for field entry details"
End Sub


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jrwaguespack wrote:
I found the name of the form field bookmark (Text5). I checked the
'calculate on exit' property of the form field (the information that
I had typed in the shaded part of the text form field disappears). I
then created the REF field (Control+F9) on the second page. I then
typed in REF and the form field bookmark name within the brackets (
{REF Text5} ). Then I saved the document. When I opened it back up,
there was nothing on the second page. I also tried to type something
into the text form field on the first page and nothing happened with
the REF field on the second page. Any more advice?
"Graham Mayor" wrote:

You need to note the form field bookmark name that you wish to
reproduce then use a REF field to call this bookmark and to insert
the duplicated data. Check the 'calculate on exit' property of the
form field so that the REF field is updated with the inserted data.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jrwaguespack wrote:
I have created a document that has two different text form fields on
the first page. Within the shaded portion of the field, I typed a
word so the user knows what to type in the field. I then saved this
document and distributed it. Each user opens the document and
enters the relevant information in each field and saves the
document. Each document is saved with a different name. The same
two text form fields are on the last page of the document as well
(with the same word typed in the shaded area as a reference for the
user). My question is how can I get the informatiion entered into
the two form fields on the first page to automatically be placed in
the two form fields on the last page? I have tried the REF fields,
but it only updates the REF field with the information that I
already have typed into the shaded area as reference information
for the user. Any help would be greatly appreciated.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
fix incorrect adding numbers from multiple text form fields Pam in California Microsoft Word Help 1 March 16th 05 10:57 PM
Enter data in 1 text form field & have multiple locations fill Lee Microsoft Word Help 1 March 16th 05 10:56 PM
Forms- adding numbers from multiple "Text Form Fields" dogfly Microsoft Word Help 4 February 18th 05 05:45 PM
Protected Fields in an Online Form hnyb1 Microsoft Word Help 5 January 19th 05 02:52 PM
Email a protected document that contains Text Form Fields Dowza New Users 1 January 8th 05 10:31 AM


All times are GMT +1. The time now is 04:31 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"