I have a recordset (rst) which I have created using an OpenRecordset Method on an existing table...call it t_Employee:<BR><BR><pre class="ip-ubbcode-code-pre"> ...

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.

Learn the differences between Is Null and IsNull() in Access Your email has been sent How many null values exist? What is the difference between a null value and a blank entry? This article answers ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.