Insert Date into Field2, the first Time Field1 is Populated with Dataon Form

[magmike]

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

 

[Bob Quintal]

:

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.

 

[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.

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

Thanks,
magmike