Text Validation - Please Help

[andylooney]

Hi,

Please can somebody help me,

I have 2 tables, one of which i created a form so a user could type info into the form, and save to the table (tb1), the other table (tb2) has a field which consists of text, basically i want to put some validation on my form so when the user using the form types in the same text as what is in (tb2) then a message appears saying that this text already exist, try typing something else.

Please help

 

[RuralGuy]

Try using a DLookup() or DCount() in the BeforeUpdate event of your control to search for duplicates.