Adding a validation check

[migrif]

I want to add a check to a form to see if a duplicate value exists. I have done this with a table by using no duplicates allowed. In this case, I want duplicates, but just want to be made aware of them, not a hard stop. Any ideas where in the field properties I can do this? Am I in the right direction under the data tab and Validation rule?
Thanks in advance.

 

[SOS]

Actually, in the form's Before Update event you can use a DCount to look for how many matches:

MsgBox "There are " & DCount("[YourFieldNameHere]", "YourTableOrQueryNameHere", "[KeyFieldNameHere] = " & Me!YourKeyField) & " existing records that match"

 

[migrif]

That's perfect!!
Thanks

 

[SOS]

That's perfect!!
Thanks

Good, glad we could help.