I am creating a database for my company (in Access 97) and am having trouble with the =Date() & =Time() I need to automatically record what time a unit arrives on site, this works, but when you go to that record again, the date and time change to the current date and time! How can I have a date&time entered that remain fixed once a date and time have been entered?

Hi,

you should set the default value for the field in the table rather than on the form. In the design view of the table you can specify =now() and that will drop on the Date & Time when the record is created - it won't change on future viewing,

HTH

Drew

Thanx, that sorted it. There will probably be a few posts from me over the next few weeks as designing databases is not my job, it's a project I've been tasked with, and I don't know a great deal about access! I normally deal with AS400's!