prevent duplicate first name and surname

[Albert1955]

hello
I just need a simple method to prevent a member being imput twice on a form
I have two fields firstname and surname ( this is necessary)
I want to stop duplication of the same person being entered when staff use the form
How do I stop this? I have seen other varyations of this but I cannot adapt it to this particular problem.
And yes I am a real beginner!!
thanks
A

 

[RuralGuy]

Use a Domain function in the BeforeUpdate event of the control concatenating the two names to look for duplicates.

 

[Pat Hartman]

You could create a compound index that includes both columns. I wouldn't recommend it though because you may actually end up with two members of the same name. What about a father and son? Not to mention complete strangers.

The best solution is to use the DLookup() to find any existing matches and then give the user the opportunity to add a "duplicate" if necessary.