How do I update a timestamp field when another field is updated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to update a date/time field (Completed Date/Time) when another field
(Completed?) has been entered. The entry field (Completed?) is a yes/no
click field. Once the field has been clicked on (yes) I then want the date
field updated with the date and time the clicked on field was entered.
 
Put code in the AfterUpdate event of the entry field to set the value of the
date/time field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validate the number of checkboxes that can be true 0
Access Form - Lock Fields from Editing 0
Subform Tabs - Field to Field Auto Populate 1
Subforms - Date/Time 2
In access if form value is yes display next field. 1
Deny changing value in field, based on values of multiple fields 4
Date Increase 1
modified update 2

Back
Top