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

January 29th, 2012 - 01:20 am ET by magmike | Report spam
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
email Follow the discussionReplies 2 repliesReplies Make a reply

Similar topics

Replies

#1 Bob Quintal
January 29th, 2012 - 09:42 am ET | Report spam
magmike wrote in
news:
:

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.
Replies Reply to this message
#2 magmike
January 31st, 2012 - 11:20 am ET | Report spam
On Jan 29, 8:42 am, Bob Quintal wrote:
magmike wrote innews:
:

> 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
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search