Thanks again Pat. Good to know I'm not going mad. What would you recommend I do next? The issue appears to exists in MS Access 2010, 2014 and 2016. MS should address this ASAP?
The pasted records not being visible after the failed paste is not the problem - as you correctly pointed out that's to be expected when pasting a unique key. In this post attempting to paste unique keys is only a means to an end i.e. a simple way to generate a paste error.
After the paste...
Hi Pat - thanks for replying. The failure to paste a unique index into a new record is as expected. What surprised me was that after the paste failure I could go on to add records that were lost when I closed the form. Looks like the paste failure has left the form in the middle of an...
I have created a very simple Access 2010 database. It has 2 tables: tblParent and tblChild. Each has a primary key on a single numeric column: called ParentId and ChildId respectively. Each has an additional Index (No Duplicate) on text name columns: called Parent and Child respectively...