Automatic Date / Time in Access Form

[kate2272]

Hi Guys,

Thanks heaps for assisting with my last question. I would like to automatically update a new record with date / time [which is no prob with =date() and =now()] but I was wondering if it is possible for it not to live update everytime I go into the record to update information (ie. I just want the date/time to reflect when the record was commenced) ... hope this makes sense.

Once again, thanks for your assistance yesterday. Hopefully, you can help me once again.

Kind regards
Kate

[NeoPa]

This is probably as simple as adding the string =Now() as the default value of the field in the table design.

Welcome to Bytes!

[kate2272]

Hi NeoPa
Thank you ... what I've just realised is that as long as I enter data into the form then the date/time doesn't update from commencement, it only does a live update of the date/time if I haven't entered data ... grrr very frustrating!!!. Thank you once again.

[NeoPa]

No worries Kate :)

I don't pretend to understand exactly what you mean, but as long as you're sorted that's good enough ;)