[newbe]

Hi I have a number of problems with a database that I am creating, one of which is how to automatically add a date to a field in a form. This is a database that will be used by multiple users, and one of the fields is called "Date last...

Hi

I have a number of problems with a database that I am creating, one of which is how to automatically add a date to a field in a form.

This is a database that will be used by multiple users, and one of the fields is called "Date last updated". I have imported the data and locked the fields that shouldn't be changed (thanks to a reply to a previous post on here). I thought it would be straightforward just to add =NOW() to the field on the form, but that doesn't make any difference. I have also tried setting the default value of the field in the original table to =NOW() and "binding" the field in the table to that. Doesn't work either! Does anyone know how I can do this?

I also have another question for you....see my other post!!!

Thanks

Ed