How to detect same name

[johnnychow]

Hi: I need help.

the Members table has member's personal information including "first name" and "given name", it is possible to have more than one person with same first name and given name. When I am using the Form to enter members information, how to detect the members who has same first name and given name. thanks!!!!!!!!!!!!!!!!!!!

 

[RuralGuy]

In the BeforeUpdate event of maybe the GivenName TextBox do a DCount() or DLookup() of the concantenation of "FirstName" & "GivenName".

 

[missinglinq]

Since you can never be sure what order an end user will use to enter data, I'd place Allan's code in the BeforeUpdate event of the 'FirstName' Field, as well.

Linq ;0)>

 

[RuralGuy]

Since you can never be sure what order an end user will use to enter data, I'd place Allan's code in the BeforeUpdate event of the 'FirstName' Field, as well.

Linq ;0)>

That's true and it will not hurt anything if it does not match. Happy New Year Linq.

 

[johnnychow]

Thank you for your reply! I am a newbie, I don't know how to do and what is Allen's code, would you please get me an example. Thank you!!!!!!!!!!!!!!! Please.

 

[RuralGuy]

Here's some examples of how to use the Domain functions: http://access.mvps.org/access/general/gen0018.htm

 

[missinglinq]

Happy New Year's to you, too, Allan!

Did y'all have a white Christmas?

Linq ;0)>

 

[RuralGuy]

We had white before Holloween. 8^)

 

[missinglinq]

I should have known!