>I changed a form around. I added a second grid to the form. Each grid references one to many transactions per account number of the parent table. I am creating the relations through the data envrionment. When I run the code it limits them down to the account number on the parent table and displays only them, everything works perfect, when I run the same code compiled as an .exe, it shows everything in the table (no limit) and doesn't even come close to finding the right account number. How do I fix something that works? Why does this work fine interactively but not in the exe?

Is it possible you have multiple versions of the form or other code, and your project is including the wrong one(s)?