I have created a custom task form in Outlook 2003 (SP3), for work. Using given properties functionality, I have created four checkboxes that, when checked, invoke the current date in a nearby text box. This is very desirable, as it allows me to record the date through the Task Window without having to open the individual task.

The problem is that when one updates, they all update. For example, when I send a document out, I check a box and the current date fills a correlated text box. When the document comes back approved a few days later, I check a second box, and that date fills a second text box, but the first date changes, too!

I think this is happening bcause I have used the Value tab of the properties field to insert the formula, and I have set them all to "update automatically".

I have tried a lot of things, even writing code, but I really need more guidance. Can anyone help?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Full Name of current Thread Principal
http://www.eggheadcafe.com/tutorials...f-current.aspx

To store static dates that don't update every time the item is opened, you
can't use simple formulas. You need to put code behind the form. For your
scenario, I'd use the CustomPropertyChange event to update the date fields
whenever the check box fields change. See
http://www.outlookcode.com/article.aspx?ID=38

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


Jewell Dinneen wrote in message
...
I have created a custom task form in Outlook 2003 (SP3), for work. Using
given properties functionality, I have created four checkboxes that, when
checked, invoke the current date in a nearby text box. This is very
desirable, as it allows me to record the date through the Task Window
without having to open the individual task.

The problem is that when one updates, they all update. For example, when
I send a document out, I check a box and the current date fills a
correlated text box. When the document comes back approved a few days
later, I check a second box, and that date fills a second text box, but
the first date changes, too!

I think this is happening bcause I have used the Value tab of the
properties field to insert the formula, and I have set them all to "update
automatically".

I have tried a lot of things, even writing code, but I really need more
guidance. Can anyone help?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Full Name of current Thread Principal
http://www.eggheadcafe.com/tutorials...f-current.aspx