Auto Update of Form Fields

[Donald Dudar]

Can anyone help with a forms problem.

I have a two page form which includes certain fields that
are entered on page one and then the information is
repeated on the second page (for example, a reference
number). What I would like to do is have the information
which is entered on page one automatically filled into
the corresponding field on page two.

There is a second challenge. I have a field which should
calculate based on entries in an earlier field. I just
found out that the calculation is contingent on certain
additional data, also contained on the form. As a
result, the calculation would normally read If(Field
A=criteria, then calculation, If(Field B=criteria,
calculation 2, "0"))

Can anyone suggest a way to achieve either or both of
these goals.

Thanks in advance.

Don

 

[Suzanne S. Barnhill]

In answer to your first question (I don't know about the second), what you
want on the second page is a cross-reference to the form field on the first
page. Every form field has a built-in bookmark. For text form fields, these
are by default Text1, Text2, etc., but you can change them in the Form Field
Options dialog. So you just Insert | Cross-reference (Insert | Reference |
Cross-reference in Word 2002) to Bookmark: Bookmark text. In the Form Field
Options for the text form field, be sure to check "Calculate on exit" so
that the cross-reference will update automatically.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Donald Dudar]

Suzanne,

That worked great. Now all I have to do is solve the
second half of the question.

I wonder if there is some way to insert a macro or some
other routine that inserts the data based on conditions.

Thanks

Don

 

[Suzanne S. Barnhill]

For all I know, it may be possible to incorporate IF fields in a calculated
field. I just don't have any experience with this.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Cindy M -WordMVP-]

Hi Donald,

There is a second challenge. I have a field which should
calculate based on entries in an earlier field. I just
found out that the calculation is contingent on certain
additional data, also contained on the form. As a
result, the calculation would normally read If(Field
A=criteria, then calculation, If(Field B=criteria,
calculation 2, "0"))

You need to do this outside the form fields, using a plain
ol' IF field with nested calculation and REF fields. Having
"Calculate on exit" activated for the form fields will
update this, just as it does the REF fields Suzanne
mentioned.

have you ever worked directly with nested Word fields (IF
fields, especially)?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail