Hi Nadya,

Thanks for the coding tip.

I think I found my problem. The DBF is named AGENCY.DBF and the first field in the DBF is named AGENCY Char 2. When I got the error and went into debugger and looked in the LOCALS window I saw AGENCY was TYPE "O" for object. It did not list the field AGENCY as TYPE "C" for character. This must be why I get the data type mismatch error. Also, AGENCY field is one of the indexed fields.

Now I have to figure out how to get around it without changing the names of the DBF or the field because many apps use the AGENCY DBF.