compare values

[DValenti]

I have a form where users will enter data, after the data
is entered I want to compare the data entered to make
sure it exists in a sql table. I have a link to the
table. What is the best way to do this? I also want to
be able do other searches based on whether or not the
value exists in the table. Any suggestions?

 

[GVaught]

If the field value must already exist in another table in order to be
entered, then create a combo box that links to that field so that users only
have those choices to pick from. Set the properties to 'Limit to list'.

 

[DValenti]

I can't do that because there are about 50,000 records.
I need to validate that the field has accurate data
before they can save the record.