Access database form keeps corrupting!
Posted on 2007-12-04
Hi, hopefully someone can help with this.
At our company we have an Access 2003 database which was written by myself.
Recently, I have been having numerous problems with one of the forms in particular.
This form contains several live fields, 2 listboxes bound to a query, and a subform linked by the main ID of the form (Order Number) showing data from another table.
The problem I have is that when the form is opened, a record is found using the filter, and the form is then closed, I am unable to ever open the form again.
There is no error message when the form is opened, unless I try to open it in design view. Then I get the following message "There isn't enough memory to perform this operation, close unneeded programs and try operation again". Also once I received another error saying "No current record" 3021.
The form has worked ok up until recently, and there has been no change to it.
I have tried Compact and Repair, decompiling and recompiling the VBA code, commenting out ALL of the vba code from the form itself (ruling out any VBA errors). And nothing has helped.
I can restore the form from a backup of the database, but it will corrupt again once the above occurs.