I need to know how to force today’s date into a field on an Access Database for a new record and then prevent the changing of that date
Any suggestions that don’t rely on VBA?
Need more info. A function can do it from an update query. If it is a form, there are several ways of writing the current date. The last step will be to lock the field from user input which can be done through properties.
I have a feeling that you just want a date stamped on the table. In that case, create a new Date/Time field in the table and set the default value to NOW().
Do you need the date when the record was created, or the date when it’s viewed? It’s not clear from the OP.
I figured out what they were doing wrong. They had =date() in the wrong field so it was always updating to the current date when a record was viewed not the date the record was created.