Write once behavior

[Guest]

Hi

I have two datestamp fields in some of my tables, one for the creation date and one for the modification date. Each one uses, the =Now() function to generate the stamp. While the modification time can be null or changed at will, the creation date needs to be immutable once entered

So, how to set the properties so that a user can enter this once *only*. That is

if (null
Allow entr
els
Reject

Thanks

Glen

 

[Gerald Stanley]

In the table design, set the DefaultValue for the
creationDate to =Now(). Then either do not include it on
the forms at all or, if you do, set the bound control's
properties Enabled to No and Locked to Yes

Hope That Helps
Gerald Stanley MCSD

-----Original Message-----
Hi,

I have two datestamp fields in some of my tables, one for

the creation date and one for the modification date. Each
one uses, the =Now() function to generate the stamp. While
the modification time can be null or changed at will, the
creation date needs to be immutable once entered.

 

[Guest]

Thanks, much!

Best,

Glenn

----- Gerald Stanley wrote: -----

In the table design, set the DefaultValue for the
creationDate to =Now(). Then either do not include it on
the forms at all or, if you do, set the bound control's
properties Enabled to No and Locked to Yes

Hope That Helps
Gerald Stanley MCSD

-----Original Message-----
Hi,

the creation date and one for the modification date. Each
one uses, the =Now() function to generate the stamp. While
the modification time can be null or changed at will, the
creation date needs to be immutable once entered.