compare values

  • Thread starter Thread starter DValenti
  • Start date Start date
D

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?
 
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'.
 
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.
 
Back
Top