I have a field called FirstContact that I would like populated with
today's date, the first time I enter a value into the Status field.
However, I don't want that date to change ever again, no matter what I
do in the Status field.

Any ideas?

Thanks in advance for your help,

magmike

magmike <(E-Mail Removed)> wrote in
news:5e001638-4b34-4dc8-a69e-(E-Mail Removed)
:

> I have a field called FirstContact that I would like populated
> with today's date, the first time I enter a value into the Status
> field. However, I don't want that date to change ever again, no
> matter what I do in the Status field.
>
> Any ideas?
>
> Thanks in advance for your help,
>
> magmike

in the Status after updatre event, use VB to test if there is already a
date in the FirstContact field, and if there is not, then write the
date.

--
Bob Q.
PA is y I've altered my address.

On Jan 29, 8:42*am, Bob Quintal <rquin...@sPAmpatico.ca> wrote:
> magmike <magmi...@yahoo.com> wrote innews:5e001638-4b34-4dc8-a69e-(E-Mail Removed)
> :
>
> > I have a field called FirstContact that I would like populated
> > with today's date, the first time I enter a value into the Status
> > field. However, I don't want that date to change ever again, no
> > matter what I do in the Status field.
>
> > Any ideas?
>
> > Thanks in advance for your help,
>
> > magmike
>
> in the Status after updatre event, use VB to test if there is already a
> date in the FirstContact field, and if there is not, then write the
> date.
>
> --
> Bob Q.
> PA is y I've altered my address.

That was so super easy - no wonder I couldn't think of it myself!

Thanks,
magmike