notinlist disabled when issuing copy/paste append

[Guest]

When I enter data into a datasheet manually, my notinlist code works fine,
but if I try to copy & paste append from an excel spreadsheet, invalid data
can be entered - my notinlist seems to be disabled under those circumstances.
Any advice would be most appreciated!

 

[Guest]

Many events do not fire if the data is not entered manually. It will include
the Not In List, Before Update, After Update, Current, etc.

Cut and Paste really should not be used in a database, partially for this
exact reason. You should import the spreadsheet into access using the
TransferSpreadsheet method, then write code to do whatever editing is
required before moving the data to your production table.