We take a somewhat different approach to the issue of recording who created a record in a table. We define a column in each table called "WhoCreated" or something similar that has a default value set to suser_sname() - that captures the SQL Server login ID, as well as a date/time column indicating when it was created. Capturing who edits a record is more challenging - you can do that sort of thing on an Access form, but we choose to use triggers in SQL Server, and actually archive each edited record.

Wendell

Colorado, USA