I have a recordset (rst) which I have created using an OpenRecordset Method on an existing table...call it t_Employee: Set rst = db.OpenRecordset("t_Employee", dbOpenDynaset) I want to be able to ...

Use Is Null and Is Not Null in criteria expressions and IsNull () in VBA code to find Null values before they work their way into your application with unexpected and often negative consequences.

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.