I have been asked to write a VB6 program to manipulate data in a SQL database. I am learning as I go, and am stuck. I have a form that asks for user input from a file and I need to take the results of that input and look at a data table to see if a certain record exists, ie match a specific field in a table against the input. The input comes in the form of a string from a CSV file. I need to check the existing table to see if this record already exists and if not, add it by calling a stored procedure. I have connectivity to the database and can print out the field for each record, but my attempts to verify if the input already exists have failed. I have tried a While Not EOF loop with an If statement to check "if strInput = objRec("name") Then" with the intention of using a Boolean variable if the two match, but that just does not work. I have a dummy file that has entries that are already in the db, but I don't get a match. I have also tried using the Find method, but I don't know how to incorporate since Find just stops on the field if it finds it??? This is the first ADO program I have attempted and I am struggling. I have searched the internet for sample code, but I am out of ideas. I would appreciate suggestions on the best way to approach searching a recordset to see if a given field exists and calling another procedure if it does not.