I am trying to run a find first method as follows: p=1 Do first.FindFirst "UniqueIdentifier = " & CStr(p) custID = first!CustomerID second.FindFirst "[CustomerIdentify] = '" & custID & "'" customername = second!customername loop while p<10 what this does, is it sorts through 10 records in one table (first) and for each one tries to find a matching customer ID number in another table (second) from which it draws the customer name. There are some instances where a record in First will not be in Second. However, it seems to arbitrarily assign it to the first record rather than give me an error of any sort saying that findfirst fails. How do I identify cases where the findfirst method does not find anything? Thanks!