I have a couple of forms that track the status of our orders. In both forms I would like to update a date field in a table as the data the checkbox was checked as well as send an email to the customer about the status of their order. As a bonus (not really necessary) I would like to blank out the date field if the box is UnChecked.
One form is based on the table that contains the field I want updated but the 2nd form is based on a query. The query has no joins so it produces an updatable recordset.