set the date to be date of today when action successful is ticked

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

Guest

I've got a form with 16 actions for customers and when the customer is
entered all these 16 actions (records) are entered but action successful is
not ticked and the date of action is automatically the date the actions were
entered. When action successful is ticked i change the date to the date of
that day i.e. date(). Is there any automatic way that after updating Action
Successful the date should change to the date()
 
Assuming the text box for the date is named txtCompleted, in the After Update
event for the check box:

Me.txtCompleted = Date

To do this, in form design view right click the check box, click Properties,
click the Event tab, click After Update, click the three dots, click Code
Builder, click OK, and enter the code.

The date will change any time the user clicks the box, so you may want to
disable the check box once it is checked (or something like that).
 
Thanks for your help - that did it!

BruceM said:
Assuming the text box for the date is named txtCompleted, in the After Update
event for the check box:

Me.txtCompleted = Date

To do this, in form design view right click the check box, click Properties,
click the Event tab, click After Update, click the three dots, click Code
Builder, click OK, and enter the code.

The date will change any time the user clicks the box, so you may want to
disable the check box once it is checked (or something like that).
Click to expand...
 
Back
Top