Setting A Date

[PhilipBenno]

Hello

I Have a form with a check box (job Completed) when this is set to true I
want the date in another field set to the date it was checked

 

[Arvin Meyer [MVP]]

A little piece of code something like:

Sub [job Completed]_AfterUpdate()
If Me.[job Completed] = True Then
Me.txtDateField = Date
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[PhilipBenno]

Hello

Thanks for the response tried what you said ,access comes back with

Object doesn;t support the property or method, if i put in Now() it works
but puts
a time stamp after the date field

 

[Arvin Meyer [MVP]]

You probably have a missing reference. Check out Doug Steele's web page:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access