Hi,

> Bless you for that simple but effective solution! The only problem now
> is that the newly inserted record comes up with all fields marked as
> deleted until you close the form and reopen it - at which point all is
> as it should be. Any thoughts - apart from getting them to ditch Access? ;-)

my guess would be that access thinks that the record was deleted because
the trigger changes the key value "under the hood" without access
noticing it. How about giving them an editable view of the table that
doesn't include the key column? Would this work?

kind regards,
Michael