niether of those programs will fix the way you are creating your recordsets.
the way you are creating the recordsets is at the heart of the problem.
your recordsets are created as:
SELECT * FROM gardner, carpcompany WHERE carpcompany.id_tb = gardner.id_tb
SELECT * FROM carpcompany";
in the first recordset, you really only need the data from the Gardner table:
SELECT * FROM gardner WHERE carpcompany.id_tb = gardner.id_tb
you probably dont even need the where clause.