Set Date Value

[goaksmith]

I went to this link

http://www.access-programmers.co.uk...2&highlight=update+field+on+current+form+only

And I basically want to do the same thing. I want the date to be the current date when the field is entered. However, I tried to set the date field to Date(). However this changed the date in every record to the system date. How do I make it so it populates with the system date and then it does not change?

 

[charityg]

You need to store the date in a field in the table, and make sure the textbox you are setting to the current data has the Control Source property set to the date field in the table.