=Date() & =Time() help?

[wh00t]

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?

 

[KDg]

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

 

[wh00t]

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!