time stamp in access

[billmush]

I'm having a problem with access taking the time and adding it to the next empty record before any thing else is added. Is there any way to have the time not be entered until the record is completed Right now in the table properties I have the Field time default set to Time$() and have a seperate date field, Customer # field, In Field and ID Field

example: ......rec1 .........rec2
CUSTOMER# 12345____(BLANK)
TIME:........10:54:50p..10:54:52p
DATE:........03/11/04....(BLANK)
IN:...............In...........(BLANK)
ID:................1.......(AutoNumber)

after 10 min have passed the time does not refresh you have to exit table and re enter it. for it to update

thanks in advance

 

[bat17]

The time will be created when the record is created. What you could do is to add an afterUpdate event to one of the other fields that will set the time for you when it is edited. One thing that you might want to look out for is whether the code should be alowed to run again if the field is edited at a latter date.

Peter