Access form won't open, "Not enough memory"

Thanks for your quick response.

How can I compact and repair?
The second computer is fully updated.
I cannot open design mode, I can get to the code.

In Access 2010 Click databasetools|compact and Repair database.

Something else you can do is move the contents into a new database.  this often resolves problems like this.

1. Make a backup copy of your original database.
2. create a new blank database.
3. import all objects from old database into new blank database.
4. test if you can now edit and view your forms.

Finally, if you still cannot get access to the form, then I would save all my work and do a system reboot. To ensure that my system is not experiencing a memory glitch.

I can't even open the form to copy it.
However, as most of today's work was VBA, I just opened a backup, copied in the new code, and it seems to be working. I did backup again after redoing my changes to the form's design - and hope there will be no more issues.

Thanks for your help!

<<and hope there will be no more issues.>>

There almost certainly will be.
Once an object gets 'brittle' the more you mess with it the more likely it is to go south.
I'd rebuild the object per my instructions sooner rather than later.  Been there, done that.

Note too that it is a very dangerous thing to edit objects in both Access 2010 and Access 2003.  Go ahead and create an autoform in Access 2010.  Now open the file in Access 2003 and begin to mess extensively with the design.  Within half an hour, you will have a corrupt object.  Pick one version or the other for development!  And keep good backups

Can't do that until the office gets in a new computer for one of the users. Should be here this week. I restored a backup version of the table - should I expect problems?

<Can't do that> What? <keep good backups>

All it needs to be is a copy of the file, in another folder, on a thumb drive, whatever
<should I expect problems>

In my experience, the problem object continues to have problems--especially if it's design is being altered--until it is rebuilt from scratch.  Copying the object and pasting won't do!

What about copying the controls on the object to a new blank form, along with the code?

<4. Copy all the controls from the old object>

That's the idea.
Create a new object in design view
Open the old object in design view
Copy EVERYTHING about the old object (controls, code, recordsource, background picture or colors, tiling of background picture ect) onto the new object so that you have a perfect replica)
Close and rename the old one
Give the new one the old one's name
Test

Got it!
Thanks for your help!