Lotus Notes FAQ Visit Our Sponsor!

How do I refresh a document's fields after one field is changed?

Place this in the exiting event of the field that will trigger changes in other fields:

Sub Exiting(Source As Field)
  Dim workspace As New NotesUIWorkspace
  Dim uidoc As NotesUIDocument
  Set uidoc = workspace.CurrentDocument
  Call uidoc.Refresh
End Sub

The "Refresh fields on keyword change" option does not work on anything other than static keyword lists.
One bad side-effect is that the uidoc.Refresh will cause all the field input validation formulas to be run; you may want to cause the refresh to happen only if all the fields with input validation have been filled in.

Applies to Notes Versions: 4, 4.5, 4.6, 5
Last Modified: May 21, 1997