Capturing current date after user checks Yes/No

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

Guest

I have a table that track payments. Multiple users can update the records.
The query has a Yes/No check box. I need to capture the current date when the
user checks the box (Sets value to True). I've tried the expressions --
Expr1: IIf(PaymentCleared=True,Now()," ") -- The problem here is that the
field gets updated the next day along with my system's date?

Is there an expression I can built or do I need to do this using VBA code?

Please help!
 
You would need to do this with code in the after update event of the check
box.

If Me.PaymentCleared = True Then
Me.txtSomeTextBox = Now
End If
 
You need a field named PaymentDate in your table. Put the following code in
the Checkbox's AfterUpdate event:

Me!PaymentDate = Date()
 
Back
Top