<div>
It's not working- here's the code:<br />
Sub ChkSold_AfterUpdate()<br />
If Me.ChkSold = True Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.txtSoldDate = Date<br />
&nbsp; &nbsp; End If<br />
End Sub<br />
<br />
txtSoldDate control source is the sale date field in my sale table<br />
txtSoldDate is the name<br />
What else could I be doing wrong?
</div>


<div>
This is fairly standard code.<br />
I can't see a reason why it might not work.<br />
<br />
Please Post a sample of this database.<br />
<br />
JeffCoachman
</div>


<div>
I tried it again. &nbsp;IT WORKS- &nbsp;thank you that answer was straight forward and simple. &nbsp;increased points<br />
come back and answer me anytime- 
</div>


<div>
Simple fast response- Wonderful!
</div>


<div>
<div class="content wysiwyg-content">
Need to know how to add a checkbox, and when the check box is checked, insert current date into the date<br />
field box. &nbsp;How do I do the statement in the expression builder?
</div>
</div>


Need to know how to add a checkbox, and when the check box is checked, insert current date into the date
field box.  How do I do the statement in the expression builder?

It&amp;#39;s not working- here&amp;#39;s the code:
Sub ChkSold_AfterUpdate()
If Me.ChkSold = True Then
        Me.txtSoldDate = Date
    End If
End Sub

txtSoldDate control source is the sale date field in my sale table
txtSoldDate is the name
What else could I be doing wrong?

This is fairly standard code.
I can&amp;#39;t see a reason why it might not work.

Please Post a sample of this database.

JeffCoachman

I tried it again.  IT WORKS-  thank you that answer was straight forward and simple.  increased points
come back and answer me anytime- 

MS Access 2003 and 2007 Add a checkbox then automatically update the date field with the current date

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.