Date/Time when new record is saved, not created

ChrisNeal1990

Registered User.
Local time
Today, 05:07
Joined
Mar 25, 2017
Messages
11
Hi all,

Is there a way I can I have a new record store the date & time of completion opposed to the date/time of creation?
 
What do you consider the completion vs creation?
 
So my form is a multi-user data entry form, when the user opens the form the current date & time is populated, however the user may not actually need to create a new record for say 30 minutes and when they do so the date/time field remains unchanged.
 
Don't fill that control until the BeforeUpdate event of the form.
 
The field auto-populates on creation of a new record? I tried requery upon completing the new record however that didn't work.

Do you mean for the users to manually complete that field or is there a way to postpone when that field is populated?
 
I'm not sure why the field "auto-populates" on creation but adding a If Me.NewRecord Then Me.YourControl = Now() to the BeforeUpdate event of the form will overwrite it.
 
Last edited:
Yeah that works, great thank you.

The field auto-populates as I set now () as default value when creating the table initially.
 
Excellent.Glad we could be of assistance.
 

Users who are viewing this thread

Back
Top Bottom