I just helping someone with an acc2010 database. Created 2 tables, Investor, Investment and a junction table InvestorhasInvestments.
I entered data by means of a Form, and purposely tried to get the duplicate record error (3022) by attempting to insert multiple Investor - Investment records (1,3). The records did not get entered. However, the autonumber was incremented for every attempt (see the table below IDs 4-21).
Access did not give an error, nor any warning that I was trying to add a duplicate record.
I did modify code to do a DCOUNT > 0 and it would display my message box. I then commented it out, and commented out my attempt to trap the 3022, but NO error message/warning/nothing was received.
Do you have to turn Errors ON with acc2010. This is my first form/report with Acc2010?
ID Investor Investment 1 1 1 2 1 2 3 1 3 22 2 2 23 2 4 24 2 5 25 2 6 26 3 1 27 3 4 28 3 5 29 3 7 30 4 9
The database and related info can be found at post#12
https://www.accessforums.net/access/...ord-30358.html
AH Ha Moment: Just realized I did not have dbFailOnError on the execute!!!!