PC Review


Reply
Thread Tools Rate Thread

How to auto-update REF fields if related ASK field bookmark is upd

 
 
DENCAS44
Guest
Posts: n/a
 
      13th Dec 2007
Have setup ASK fields and related REF fields with corresponding bookmarks.
When the ASK field is updated and bookmark contents are changed, I find that
the REF field values do not automatically update except if updated
individually. Is there a way to make the REF fields automatically change
when the bookmark changes without using macros? The Microsoft command,
UPDATEFIELDS seems to work but you must first highlight the document to
include all of the REF fields. Auto-updates of REF fields would seem to be a
typical application without resorting to macros in order to correct errors,
template changes, etc.

Any suggestions?
 
Reply With Quote
 
 
 
 
Stefan Blom
Guest
Posts: n/a
 
      17th Dec 2007
Well, Word has a built-in option to update fields on print, but it may not be
what you want, since it also triggers an update of the ASK field itself.

Instead, you can switch to Print Preview and back (by pressing Ctrl+F2
twice); this will force an update of REF fields (and certain other fields,
such as SEQ fields).

A third option is to use a macro that updates the REF fields. This can be
done in several different ways. Personally I'd prefer to update the fields
prior to printing the document, for example, by intercepting the FilePrint
and FilePrintDefault commands. Put these macros in an add-in, or in
normal.dot:

Sub FilePrint()
Application.PrintPreview = True
ActiveDocument.ClosePrintPreview
Dialogs(wdDialogFilePrint).Show
End Sub

Sub FilePrintDefault()
Application.PrintPreview = True
ActiveDocument.ClosePrintPreview

ActiveDocument.PrintOut

End Sub

For assistance, see http://www.gmayor.com/installing_macro.htm.

--
Stefan Blom
Microsoft Word MVP


"DENCAS44" wrote:

> Have setup ASK fields and related REF fields with corresponding bookmarks.
> When the ASK field is updated and bookmark contents are changed, I find that
> the REF field values do not automatically update except if updated
> individually. Is there a way to make the REF fields automatically change
> when the bookmark changes without using macros? The Microsoft command,
> UPDATEFIELDS seems to work but you must first highlight the document to
> include all of the REF fields. Auto-updates of REF fields would seem to be a
> typical application without resorting to macros in order to correct errors,
> template changes, etc.
>
> Any suggestions?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill of related fields in a form =?Utf-8?B?U3Rhbl9C?= Microsoft Access Forms 6 11th Oct 2007 05:17 PM
2 Related field or Auto fill up 2nd field after 1st field entered =?Utf-8?B?S2FvbGk=?= Microsoft Access Getting Started 1 17th Sep 2006 11:40 AM
How to auto-fillin related fields? hkgary33 via AccessMonster.com Microsoft Access Forms 2 12th Jul 2006 02:29 PM
form & subform auto update related field Maggie Microsoft Access Form Coding 2 12th May 2004 12:55 AM
How to auto update related fields Kath Microsoft Access 5 31st Mar 2004 08:12 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:33 AM.