Auto populate date field with current date IF anything on the form is revised.
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?
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.