On a customer database I am creating, I am trying to put an automatic date field in - but one that DOES NOT CHANGE each time the record is entered. I know this is probably an easy problem.. but one that I cannot do. I have tried date(), now() etc but still no joy - they update each time the record is accessed. Any help would be much appreciated. Thanks..

If you want to use an "enteredby" date use something like

txtDate=now() in the form's beforeInsert event.

In the On Current event of the form you can use code like this to accomplish your goal.

If Me.Newrecord Then
Me.DateField = Date()
End if