Access returns an incorrect record ID when a form is bound to an SQL Server table that has an 'insert trigger' that inserts a record into 'another' table. The record ID returned is actually the record ID of the trigger inserted record into the 'other' table. This is because Access calls SQL Server for @@IDENTITY rather than SCOPE_IDENTITY() when inserting a new record. This particularly affects SQL Server tables that are 'replicated' as these tables have an MS shipped 'insert trigger' on the table for use in replication. We have an MS Support Case # 23043471 where we have had no resolution ...