SteveL13

President / Owner CARDA Consultants Inc.

Daniel Pineault

<div>
<div class="content wysiwyg-content">
I have a form with two date fields. &nbsp;One is DateCreated &nbsp;(txtDateCreated), which is a manual entry field. &nbsp;The other is DateRevised (txtDateRevised). &nbsp;If the user makes a change in the form OR sub-forms, I want DateRevised to populate with the current date. &nbsp;How can I do this?
</div>
</div>


I have a form with two date fields.  One is DateCreated  (txtDateCreated), which is a manual entry field.  The other is DateRevised (txtDateRevised).  If the user makes a change in the form OR sub-forms, I want DateRevised to populate with the current date.  How can I do this?

Auto populate date field with current date IF anything on the form is revised.

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.