In a record in a subform on a form, I need to empty just one field called LICENCESTATE in the record. The following AfterUpdate code in a field called STATE works fine i.e. If FAMILY "BUPRESTIDAE" Then LICENCESTATE = Null. Access then happily clears the LICENCESTATE field. But code that I need to run to clear the LICENCESTATE field if two conditions are met, that is, if the field called FAMILY does not equal "BUPRESTIDAE" and also if the field called RESERVE is empty, Access does not clear the LICENCESTATE field. My code is If FAMILY "BUPRESTIDAE" And RESERVE = "" Then LICENCESTATE = Null. Any suggestions? Many kind thanks, Allen