Failure adding Option Group to an existing Form

[MSAccessRookie]

I want to add an Option Group to an existing Form to describe the management type for certain projects (Internal=1, External=2, Other=3). The Selected value is to be stored in a new Field of an existing Table. The new Field has been defined as type Number, and Size Integer and pre-populated with the value 1 to indicate the default value of internal management.

I am created the Option Box using the Creation Wizard, defining the choices, their related values, assigning the default, pointing the result at the newly created Field, and giving the Option Group a Title. Every time I try to save the Form, or even to exit Design Mode to test the Option Group, Access Crashes, and the Option Group related changes are lost.

I found a Forum entry in the Archives where RuralGuy suggested solution to a similar problem, so I tried that before posting here. I created a new Blank Database, imported all of the Database Objects, and no errors were reported. I then proceeded to Compact and Repair the new Database and no errors were reported.

I created another Option Box, and had the same Failure as before.

Does anyone else have another idea as to why this might be happening?

-------------------------------------------------------------------

RuralGuy's suggested solution to a similar problem:

http://www.access-programmers.co.uk/forums/showthread.php?t=151609

 

[sparks80]

Hi,

It is possible that the form has corrupted, despite copying the objects over into a new file.

One possible solution is to copy all the objects from your existing form onto a new one, then add the option group and see if your form will now save. You will need to copy over any VBA code manually, and make sure that code for any form or control events is linked up properly afterwards.

 

[MSAccessRookie]

Hi,

It is possible that the form has corrupted, despite copying the objects over into a new file.

One possible solution is to copy all the objects from your existing form onto a new one, then add the option group and see if your form will now save. You will need to copy over any VBA code manually, and make sure that code for any form or control events is linked up properly afterwards.

Sorry for the delay in responding, but it took a while to replicate the Form. Once the Form was replicated and saved, I was able to modify it to add the new Option Group.

Many thanks for the idea. While I am not sure how or why it worked, what is important is that it did work.

 

[missinglinq]

...I am not sure how or why it worked...

It almost assuredly worked because your Form was, indeed, corrupted! Alan's (RuralGuy) suggestion is always the first one to try, because it requires relatively little work and frequently succeeds. But as you've found out, it doesn't always work! Sometimes the solution you've used doesn't work, either, and you're reduced to actually recreating the entire Form from scratch! But the Access Gnomes were kind to you...this time!

Glad you got it up and working, again!

Linq ;0)>