Run-time Error '2342' states:<BR>"A RunSQL action requires an argument consisting of an SQL statement."<BR><BR>I am having some issues with an inline query to sum up ...
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.