unable to open form!!

[tom91]

hi, i have created a database in access for my school ICT project. today i was writing code to enable a toggle button to appear, disappear depending on the contents of a text box. when i clicked off it would not allow me to open the form it was on and this message comes up now : "There isn't enough memory to perform this operation, close all unneeded programs and restart the operation". it also does this an all pc's i have tried. But it will allow me to open the rest of my forms. i really need some help!

 

[CEH]

Sounds like something has corrupted the form. Do you have a backup for the DB? If so, delete that one form from the current DB and import it from your backup. If not, your probably looking at reconstructing the form. Always a good idea to do periodic saves when working on a project. You'll be glad you did when things like this happen.
One other thought... Can you open the form in design view? IF so, open it, remove your toggle code and see if that makes a difference.

 

[tom91]

hi, yes i do have a backup of it, i will probably have to do that and no i cannot open it in design view. Thanks