Date stamp from check box

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

Guest

I have a check box called Loadtxt and when it is ticked I want the value of a control called EmailDatetxt to be today's date. I am using this code in the AfterUpdate event of the checkbox but it doesn't work.
If Me.Loadtxt = True Then
Me.EmailDatetxt.Value = Date
Else
Me.EmailDatetxt = Null
End If

Anyone any ideas?
TIA
 
When/where doesn't this work. It should work as you check/uncheck the
textbox, but if the value of the check box is remembered from visit to the
record to the next (i.e. the checkbox is bound to a field) you will also
need to run this test in the form's Current event.

--
Wayne Morgan
Microsoft Access MVP


Tony Williams said:
I have a check box called Loadtxt and when it is ticked I want the value
Click to expand...
of a control called EmailDatetxt to be today's date. I am using this code in
the AfterUpdate event of the checkbox but it doesn't work.
 
Thanks Wayne. I expected it to work when I checked the box but it doesn't. Also I get anerror message that says can't find Date field yet I thought Date was a VB function?
Tony
 
Back
Top