Saving changes to a form

[Guest]

John Vinson started to reply to this same Q on 5/29/08.

I am having the exact same "Weird" problem and I didn't see the answer posted.

I have been working on a long established form, wanted to add another field
but then it doesn't save. The only way to close the form (from any view) and
the only way to close the DB is to choose no and lose the changes made to the
form. I have saved in the past, but all of a sudden it won't save. All the
properties are set to allow changes.

I have even tried to copy the form, rename it, etc. but then I get an error
of either "Name AutoCorrect Save Failers" if I totally change the name or
"The search key was not found in any record" if I leave the name as "Copy Of
...."

This is our main data entry form it is multi-tabbed and I'd HATE to have to
rebuild it. I am working in Access 2007.

Can anyone help?

 

[Guest]

OK, after doing more checking, I found a fix, but I don't know why it works.

Johnopal fixed his same problem from 10/17/08 by ...
"I must have had some VBA code attached to these forms somewhere along the
way and it didn't convert. I opened the form in design mode clicked "view
code".
This created a new module with no code. I closed it and viola! the form
would now save with no problems. This method seemed to fix all of the forms I
was having trouble with."

At our firm, we don't know enough about VBA to work in it. How did I get
"Option Compare Database" in my VBA window?

All I did was delete the statement and it works. Is the statment something I
need?

 

[John W. Vinson]

At our firm, we don't know enough about VBA to work in it. How did I get
"Option Compare Database" in my VBA window?

It gets put in automatically if you create a new module (e.g. by opening a
form's module).

All I did was delete the statement and it works. Is the statment something I
need?

Not if you don't have any other code, no.