Message box for duplicate entry...

[anbusds]

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 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!!!

 

[pbaldy]

Generally speaking, you can use the before update event of the form or a specific control:

http://www.baldyweb.com/BeforeUpdate.htm

In your case, the test would be a DCount() using the 2 fields in the criteria:

http://www.mvps.org/access/general/gen0018.htm

A count greater than 0 indicates a combo already exists.

 

[anbusds]

Hi Paul,
I have 5 text boxes if i input the duplicate entry again on the same 5 text box values, i would like to have a message box..
Thanks for your reply!!!

 

[pbaldy]

2 or 5, the same method will work, it's just a more complicated criteria.