View Single Post
  #3  
Old August 4th 07, 01:41 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Modifying Contact Form with Last Updated field

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

Ads
 

Mobile Phone - Discount Magazine Subscription - Credit Cards - Credit Cards - Remortgages