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

[Peter Paul]

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]

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.