Here's my problem (keep in mind that I'm not exactly an Access pro which is evident by the problem I have).
I have a primary key set in my table but HATE that tacky error message that Access pops up when someone tries to enter duplicate information. I know a validation rule & text would help, however I don't know the code that won't allow duplicates to be entered. Since Access pretty much takes care of that part for me - I really just need to know how to customize the error msg that comes up when a duplicate value is inserted.
Many thanks in advance for any assistance!