Updating a time field when a record is created (1 Viewer)

Peter Paul

Registered User.
Local time
Today, 09:52
Joined
Jan 1, 2000
Messages
82
I am attempting to create a refresh option for a time field. This is a form which we use to record radio communications. I have the time entered automatically using a Time()expression. But when I enter onto a new record, and the time sets, it may be a while before the next entry is made. However, the time will not refresh to the moment the new record is created. I need to know how to link the first entry with a refresh option for the time field.

[This message has been edited by Peter Paul (edited 01-01-2000).]

[This message has been edited by Peter Paul (edited 01-01-2000).]
 

Travis

Registered User.
Local time
Today, 01:52
Joined
Dec 17, 1999
Messages
1,332
try setting this on the AfterUpdate of the primary field on your form.(The field that must have data):

me.TimeField=Time()

By doing this you can remove the initial time stamp function and now have the entries stamped at exactly the time they were created. You could then Lock the TimeField and thus reduce user entries and errors.
 

Users who are viewing this thread

Top Bottom