optionGroup - error

[Sheba]

what could be wrong now...
I have below, code for my option group (Frame1196). "Spine" is the table field name but I keep getting this error even though the option group exists on the form. Help me Please!

If Me.NewRecord Then

Me.Frame1196 = Null

Else

Me.Frame1196 = Switch(Me.Spine = "Yes", 1, Me.Spine = "No", 2, Me.Spine = "Unknown", 3)

[ItsMe]

The error indicates that you do not have a control named "Spine" in your form. Also, 1200 controls on a single form is a lot. Even if you have deleted most of them during development, consider rebuilding your form by creating a new form object. You can copy over good controls using copy/paste. Use the ellipses in the property sheet or the pull downs in the VBA editor to recreate the sub procedures. Option groups cannot be pasted into a new form. They must be created using the wizard.

[Sheba]

Many thanks ItsMe. The form control is named "Frame1196". It is the table field that is called "Spine". However your advise is noted I'll try creating a new Optionsgroup for this one