duplicate field enty - indexed - hyperlink field

[captainrod]

Field: referral-web



Type: hyperlink

Indexed set to " yes - no duplicates " ((I want to prevent having duplicate website addresses)).

It allows me to enter the duplicate data and when I go to the next record, it gives me the error message.

Unfortunately, I have entered 20 fields of data after the "indexed yes" field.

How can I get a warning etc after I enter the duplicate data without filling in the additional 20 fields of data?

First time posting. Hope I did it correctly.

[Gicu]

In the BeforeUpdate of the control bound to [referral-web] add a validation using a dCount:

if dCount("*","tblYourTableName]","[referral-web]=""" & Me.txtReferralWeb & """")>0 then
msgbox "You already have this web site!"
Cancel=True
End if