Hello everyone. I am wanting to store the date the record was entered into the table. But I don't want the users to have to type this in; I thought that Access could grab the date from the system date.

I am new to this and I looked at the Date function but I am thinking it will just always update to the current system date.

Thank you very much if anyone could point me in the right direction.

Add a field dtmRecAdded and set it to date format with the default value being Now()
Every time a new record is added it will catch the date and time
Hope this helps

In the default value property of the field enter =Date()

Thank you very much everyone. It worked. :)