Message box for duplicate entry...

Dear all,

I am using access 2003 i would like to prompt message box should come out for adding the duplicate entry..

Example:

ID:1

User:a

i add the this record to my MySQL table from my access form by clicking the submit button then text box value become null, if i type again the same ID 1 and user a i need to have a prompt message "This is duplicate entry do you want to proceed" if yes proceed to add if no hold the action...



Thanks in advance!!!

Message box for duplicate entry...