Rey Obrero kindly gave me a loop that works perfectly on two computers in the sample database we shared. When I copy the code to the same form on the original database I get a compile error "user defined type not defined" at Dim rs AS DAO recordset. My research indicates that I'm missing the MS DAO 3.6 Object Library but I can't load it. I've tried the Mr. Fix It tool from MS without joy. Don't have a lot of enthusiasm for manually working with the registry but could if needed with good instructions. In the References list there are no missing items and VBA, Access 14.0 and VBA Extensibility objects are checked. I've included the sample database and the original for comparison. Any assistance would be greatly appreciated. Thanks!