I have a form which controls a database, I would like to add the date
and time that the new entry was made into the database to be stored for
reference. I have put two records in the database, one is DateModified and
the other is Time Modified. How can I get the form to add the date and time
to the form so that it will not be changed when I get in to edit the form?
I would like to have it be locked once the information is entered so that I
can look and see when the record was added to the database.
Should I use a expression or a macro? I need to know how to build
either.

Thanks In Advance
Bill

On Wed, 21 Jul 2004 17:49:48 -0400, "Hulk" <(E-Mail Removed)>
wrote:

> I have a form which controls a database, I would like to add the date
>and time that the new entry was made into the database to be stored for
>reference. I have put two records in the database, one is DateModified and
>the other is Time Modified. How can I get the form to add the date and time
>to the form so that it will not be changed when I get in to edit the form?
>I would like to have it be locked once the information is entered so that I
>can look and see when the record was added to the database.
> Should I use a expression or a macro? I need to know how to build
>either.
>

First you don't need one field for data and another for time. They are
the same thing - it just depends on how the date/time is formatted.
Besides it doesn't seem logical to have a modified date/time yet not
allow modifications.

So, what you might do is create a field for DateCreated and set its
Default Value in the table to Now(). When a new recorded is created it
will be time stamped with the date/time.

On the form don't allow edits by setting the textbox Locked property
to Yes

- Jim