"Frank Martin" wrote in message
...
I have a small database and I want to record, in a table field, the date
at which a record is added (but not edited).

In table design view, add the field to record when the entry was made.

In the lower pane of table design, set the Default Value property of this
field to:
=Date()
if you just want the date. If you want the date and time, use:
=Now()

When you create a form to show the entries, don't provide a text box for
this field, so the user won't have a way to modify the date.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.