Auto dating a text field in Form

[Guest]

Hi,

I created a two columns for my tables. I want to be able to query to find
out who entered the data using the form and when it was entered so I can
query to find out how much data was entered into the system and make sure the
data are entered correctly.

1. Updated By
2. Updated Date

What I want to do in this form is basically auto date the empty text filed
of the form when user's enter information. I know something like =today()
and it automatically enter the system date but when I search the data in a
later time that date only reflect the current system date and not the date
the information was inputed into my database. It's almost like an
autonumbering column but an auto date column Please help. Also let me know
where I put the code at. i.e properties menu. Thanks bunch.

 

[Guest]

You could create a default in the table. In theDefault Value property of this
field, put Date(). Any time a record is entered, it will fill the current
date.

Barry