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