Problem saving changes to an old form

[msmithtlh]

I am trying to change a form that was created about 10 years ago. It asks if I want to save, I say yes. When it brings it back up, the changes are gone.

I tried copy and pasting the form to one with a new name, and get the following error (I am using a unique name):


"Name conflicts with existing module, project, or object library."

Any help would be greatly appreciated.

[davegri]

Try commenting out all the vba code in the original form.

[msmithtlh]

There is no vba code. However, one additional, possibly important detail. I am trying to change a form with tabs (or pages). It is the second tab I am trying to change. It seems to make the changes, when I finish adding the new fields, I save, then go to form view. All looks OK. When I close the database and reopen it, the changes are gone.

[msmithtlh]

I finally decided something had to be corrupted. I recreated the subform from scratch and it saved and is working fine now.

[Missinglinq]

Sounds as if corruption was, indeed, the problem. Next time, if corruption is suspected, you might want to try this:

From inside Access:

1. Click on the 'New' or use <Control> + <N>
2. Go to top of the Ribbon and click on External Data
3. Under that click on the Access Icon
4. Click on Browse
5. Find your errant Database File
6. Click OK
7. Tab by tab, go thru Tables, Queries, Forms, etc, clicking on 'Select All' each time
8. When done selecting all Objects, click on OK

You should now be set. If everything now works, delete the old file and rename the new one as the old. Amazingly, this works an enormous percentage of the time, and is usually easier than re-creating a Form or Forms.

Linq ;0)>

[davegri]

Yes, I've run into that sort of problem several times. I've had vba code give errors for no apparent reason, and cutting and pasting the code to another place in the same module fixes it. I really hate having to recreate a form. Such a boring waste of time, but can't be avoided sometimes.