No, this is called a "trigger" in other RDBMS' and Access does not support them. Similar functionality can be performed via a form. However, unless you have totally secured the app so that there is no way to update the table without using the form, data anomolies could be introduced.
