Using a formula for this scenario won't accomplish what you want. What you need is code behind the form to set the value when the user saves changes, e.g.:
Function Item_Write()
Item.UserProperties("Last Updated") = Date()
End Function
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Keith S." wrote in message ...
Er, I forgot to elaborate what the "problem" is. Whenever I make a change to
one of the pages of the form that doesn't contain this custom field, the
value doesn't get updated.
Keith
"Keith S." wrote:
Hi there,
I've added an extra page to the standard Contacts Form to include a few
extra fields, one of them for the "Last Updated" date. I set the Properties
for this field so that the initial value is Date(), and then check calculate
this formula automatically.
Whenever I visit that page and make a change, the Last Updated field gets
updated with the current timestamp. So far, so good.
The problem (I think) appears to be when I make a change to one of the OTHER
pages of the form, but not that page with the custom field.
Is there a way to set the field on one page to automatically update whenever
ANY part of the entry is updated?
Thanks,
Keith