Here is a sample to process a table as recordset Function is run when you open form one. It will run through the table to find a value