[Going Nuts in Fields]

I have made a template that has a Style format called Lot # this needs to be
typed in by the user of this template. Then that lot # has to appear in the
header and in a table on the next page. I have done this but when the lot #
is typed in, the header updates automatically but the table does not how do I
fix this?

[finalword]

The table will not automatically update, but you can create a Macro in VBA
and then assign it to your original Lot Number field where the user is
entering the data, and this will make sure that all fields in the document
are updated after the user leaves the Lot Number field

Here is the macro:

Sub UpdateField()'
ActiveDocument.Fields.Update
End Sub

--Select the macro and copy it
--Open your Word document
--Hit ALT + F11 to open the VBA editor
--Paste in the window on the right
--File | Save
--File | Close and return to Word

--Double click on the field where the user enters the Lot number to get the
properties box
--In the middle of the box, you should see Run Macro On, under Exit, choose
the dropd-own arrow and select your macros name.
--OK your way out of the Properties box
--Protect your form (Form toolbar | click the lock button )
--Save

Go ahead and test it


"Going Nuts in Fields" wrote:

I have made a template that has a Style format called Lot # this needs to be
typed in by the user of this template. Then that lot # has to appear in the
header and in a table on the next page. I have done this but when the lot #
is typed in, the header updates automatically but the table does not how do I
fix this?

[macropod[_2_]]

Hi finalword,

That technique would only work if the field was a formfield, in which case you also wouldn't need a macro - all you'd need to do is
set the formfield's properties to 'calculate on exit'.

--
Cheers
macropod
[MVP - Microsoft Word]


"finalword" wrote in message ...
The table will not automatically update, but you can create a Macro in VBA
and then assign it to your original Lot Number field where the user is
entering the data, and this will make sure that all fields in the document
are updated after the user leaves the Lot Number field

Here is the macro:

Sub UpdateField()'
ActiveDocument.Fields.Update
End Sub

--Select the macro and copy it
--Open your Word document
--Hit ALT + F11 to open the VBA editor
--Paste in the window on the right
--File | Save
--File | Close and return to Word

--Double click on the field where the user enters the Lot number to get the
properties box
--In the middle of the box, you should see Run Macro On, under Exit, choose
the dropd-own arrow and select your macros name.
--OK your way out of the Properties box
--Protect your form (Form toolbar | click the lock button )
--Save

Go ahead and test it


"Going Nuts in Fields" wrote:

I have made a template that has a Style format called Lot # this needs to be
typed in by the user of this template. Then that lot # has to appear in the
header and in a table on the next page. I have done this but when the lot #
is typed in, the header updates automatically but the table does not how do I
fix this?

[macropod[_2_]]

Hi,

Unless you use a formfield or put your table in the header or footer, you'll have to update the table field manually. You can do
this by doing a Print Preview, selecting the table field and pressing F9 or by printing the document. The field will also update if
you save & close the document then re-open it.

--
Cheers
macropod
[MVP - Microsoft Word]


"Going Nuts in Fields" Going Nuts in wrote in message
...
I have made a template that has a Style format called Lot # this needs to be
typed in by the user of this template. Then that lot # has to appear in the
header and in a table on the next page. I have done this but when the lot #
is typed in, the header updates automatically but the table does not how do I
fix this?

[Going Nuts in Fields[_2_]]

You can also update by right clicking the field and update. I was hoping
that I wouldn't have to train everyone on this. Was hoping for a easy quick
fix oh well such is life thanks for all your help.

"finalword" wrote:

The table will not automatically update, but you can create a Macro in VBA
and then assign it to your original Lot Number field where the user is
entering the data, and this will make sure that all fields in the document
are updated after the user leaves the Lot Number field

Here is the macro:

Sub UpdateField()'
ActiveDocument.Fields.Update
End Sub

--Select the macro and copy it
--Open your Word document
--Hit ALT + F11 to open the VBA editor
--Paste in the window on the right
--File | Save
--File | Close and return to Word

--Double click on the field where the user enters the Lot number to get the
properties box
--In the middle of the box, you should see Run Macro On, under Exit, choose
the dropd-own arrow and select your macros name.
--OK your way out of the Properties box
--Protect your form (Form toolbar | click the lock button )
--Save

Go ahead and test it


"Going Nuts in Fields" wrote:

I have made a template that has a Style format called Lot # this needs to be
typed in by the user of this template. Then that lot # has to appear in the
header and in a table on the next page. I have done this but when the lot #
is typed in, the header updates automatically but the table does not how do I
fix this?