Hi,
I really need help in my project.
I used a userform to add records. What I want to happen is that when I hit the Submit button, there will appear an error message saying that a duplicate record already exists which would depend on multiple criterias matching the record that I am trying to add.
For instance,
A B C D
1 Date Category Payment Amount
2 3/12/13 Food Cash 500
3 3/13/13 Supplies Check 10000
4 3/13/13 Maintenance Check 2000
.
.
n An Bn Cn Dn
On the userform, I have a record that would be like that in fourth entry, as I hit the submit button, I would like to see a msgbox that would say duplicate entry found, recheck entry or something. How do I compare my data from the textboxes or comboboxes in my userform to the ones already existing in the database, like check columns through A to D and see if all OR any (at least 3) criterias are matching so that the msgbox would appear to prevent user from adding the duplicate entry.
It would be good if I would have an option to still add the data if the user wants to. But that might be easy since I can add that option in the msgbox instead.
I really need your help guys, I would appreciate it! Thanks!
Bookmarks