Check if Name already exists? 4

[Bauer99]

I have a very simple Database tracking Personnel. I have a form for data entry. What I want to do is on the Before Update Event I want to check if the name has already been entered and display a msgbox. The name is Split into two fields - LASTNAME and FIRSTNAME.

I figure you need to put the Last and first name into a single string. Then loop through each record, and compare the names. But I do not know how do do this..... Anyone done this before?

 

[psemianonymous]

There's a shorthand function that does all this called DLookup. The help files will help with the specifics, but it will look *something* like this:

if Not IsNull(DLookup("[LASTNAME] + [FIRSTNAME]","[TABLE_OR_QUERY_NAME_GOES_HERE]","([LASTNAME]+[FIRSTNAME]) = '" & txtLastName & txtFirstName & "'&quot) then
'item already exists
End If

 

[Bauer99]

Great! Works like a charm....

Once again... look for the easier solution!
thanx

 

[nat35]

Hi there ,
It works for me !!
nat