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
news:(E-Mail Removed)...
>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