title: Enter data in one field and have another field update automatically
body: <p>I have an Access table named Issues with a Date field and Status field in the same table. The status field is a combo box with list value of "Open" or "Closed". I would like to enter a date in the date field and automatically change the status field from "Open" to "Closed". So, when the user enters the date in the form it will change the status to "Closed" automatically.</p>