For those with an Access application that ties into a SQL Server backend, you might be interested in reading about considerations for designing a trigger. A follow up blog post on specific consideration for Access bound form will follow shortly.
Designing a T-SQL Trigger
Excellent tips regarding use of Set (vs. Row)-based Triggers attached to a View in SQL Server.
I look forward to your follow-up article about using this with Access.