I've been battling a perplexing issue with a database form for over a month now, and I was hoping that someone in the EE community might be able to provide some insight on the issue. Basically what I'm dealing with is a form that contains a subform. The main form allows a user to add property sale records to or edit property sale records already contained in the database. The subform allows a user to enter to land use information (acres, dollars/acre, etc.) related to the sale, and automatically calculates summary information predefined expressions. The problem is that the subform will frequently fail to perform the predefined calculations, resulting in the calculated text boxes just going blank. An even larger problem is that the error is so hit and miss that I can't pinpoint the exact cause. One minute everything works fine, and the next none of the calculations in the subform work. To make things worse, no error message is generated that would help me identify the cause of the issue. I've tried repairing the database and rebuilding its components (main form, subform, calcuations, etc.) to fix this issue, but nothing works.
The following outlines the things I've tried to resolve this issue.
1. I initally thought that the database wasn't working because the original database was created on a computer with Windows XP OS and MS Access 2007, the computers that most frequently experienced the problem were machines with Windows 7 and MS Access 2007. Based on an suggestion provided on EE, I tried to resolve the issue by upgrading the Windows 7 machines from MS Access 2007 to MS Access 2010 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27346994.html
). This appeard to resolve the problem, but then the error began to occur again.
2. I eventually noticed that the error was also occuring on the Windows XP and MS Access 2007 machines, so I rebuilt the database and it's components multiple times from scratch on a machine running Windows XP and MS Access 2007 machine and a Windows 7 and MS Access 2007 machine. Same result. Based on this, I'm wondering if there is an issue with the subform or the manner in which I setup the subform calculations.
I've attached the database in question to this post. Please be advised that the database tables are normally linked to a shared database, but for the purposes of this post, I included the database tables in the actual database. I don't know that this will affect the issue I'm currently facing, but I thought that I would just put it out there. If anyone would like me to repost the database with links to a shared databse, I would be more than happy to do so.
I'm at total loss on this issue, and I hope that someone can help. Any input is greatly appreciated.