Loading Date via populating another field

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Is there a way to automatically load the date a specific
field was populated?
Example, user enters customer sales info. A few days
later, they go back to that customer's record to add a
sale completion number...so that the user only has to
enter the number and not that days date as well (just
trying to save a step I guess) can that days date be
loaded without running another query?
Thanks
 
Hi Jeff,

If the user is entering data in a form, you can add code
to the afterupdate event of the form controls that you
would like to trigger the entry of the entry date.

the code would look something like this:

Private Sub YourFieldName_AfterUpdate()
Me.LastUpdated = Now()
End Sub

The first and last lines would be entered for you by
Access. You would enter the second line, but substitute
your name for the date control where I have typed
LastUpdated. Also, if you just want the date, not the
date/time, use Date().

If you want to revise the date any time one of multiple
fields are edited, you would need to add this code to
each fields AfterUpdate event.

If they are not working in form view, they can use Ctrl+;
to enter the current time, or Ctrl+Shift+: to enter the
current date. Or, if the fields default value is the
current date or date/time, they can enter
Ctrl+Alt+Spacebar to enter the default value.

HTH

-Ted Allen
 
Awesome. Thanks!
-----Original Message-----
Hi Jeff,

If the user is entering data in a form, you can add code
to the afterupdate event of the form controls that you
would like to trigger the entry of the entry date.

the code would look something like this:

Private Sub YourFieldName_AfterUpdate()
Me.LastUpdated = Now()
End Sub

The first and last lines would be entered for you by
Access. You would enter the second line, but substitute
your name for the date control where I have typed
LastUpdated. Also, if you just want the date, not the
date/time, use Date().

If you want to revise the date any time one of multiple
fields are edited, you would need to add this code to
each fields AfterUpdate event.

If they are not working in form view, they can use Ctrl+;
to enter the current time, or Ctrl+Shift+: to enter the
current date. Or, if the fields default value is the
current date or date/time, they can enter
Ctrl+Alt+Spacebar to enter the default value.

HTH

-Ted Allen
.
Click to expand...
 
Back
Top