Comparing value entered in a textbox to a value present in a table

[hayeutino]

I just wanted to compare a text entered in a text box to a text present in a table ?

 

[John Big Booty]

The DLookup() function or one of the other Domain Aggregation function should do what you are after.