I'm using MS Access 2003.
I have a subroutine with the following statement at the top:
along with the corresponding :ErrorHandler section at the bottom.
I also have a table with a column that is indexed with No Duplicates.
I notice that if Access encounters a duplicate key error with this table within this subroutine, the ErrorHandler section does not fire. Rather, an error message appears saying Runtime error: Type mismatch.
How can I make this error message more user-friendly if it won't invoke the ErrorHandler section?
Thanks for any help you can give.
Wayne
I have a subroutine with the following statement at the top:
Code:
OnError GoTo ErrorHandler
along with the corresponding :ErrorHandler section at the bottom.
I also have a table with a column that is indexed with No Duplicates.
I notice that if Access encounters a duplicate key error with this table within this subroutine, the ErrorHandler section does not fire. Rather, an error message appears saying Runtime error: Type mismatch.
How can I make this error message more user-friendly if it won't invoke the ErrorHandler section?
Thanks for any help you can give.
Wayne