error message if multiple index is violated

[sprite66]

Hi,

I'm creating a contact information database. I have created a multiple field index for first and last name and I would like an error message to appear as soon as these two fields are filled if the contact is already in the database. Is there any way to create a validation rule for two fields?

Any suggestions about how to get an error message to display "Contact already in database" would be greatly appreciated.

Thanks in advance

 

[VicRauch]

In the AfterUpdate event of both fields have code that will call a CheckForDup() function. By putting it into both fields, any changes will always be checked.

The CheckForDup() function would then do a DLookup to see if the name is already present.

ReturnValue = DLookup("RecordID", "tblContactInformation", "FirstName='" & Me.FirstName & "' AND LastName= '" & Me.LastName)

This line of code will put the RecordID into the ReturnValue variable if there is a record that matches.

HTH,

 

[giacomo]

Not sure what you're using this database for but one thing to consider is that it's not that uncommon to have different contacts with the same name.

 

[sprite66]

Thank you both for your help...I have it figured out now.

Giacomo, thanks for the resource links