Error ==> You can't assign value to this object

[New_Access]

I have a code on 'on load' event of my form.In the beginning,
it did work for me but now It won't.Why?
I bound all text boxes to a table field with data type is text.
And bound all optiongroup ( fra_.......) to fields number.
But now there is an error message from VBA :

Error -2147352567 ( 80020009 )
You can't assign value to this object

Why?Any assist would greatly appreciated.
Thank's.


Private Sub Form_Load()

Me.SpeedMode_opt = 1

Me.fra_Rotationspeed1 = 1
Remarkrotationspeedspec1.Value = "Min"

Me.fra_Freeaircurrent1 = 1
Re_freeaircurrentspec1.Value = "Min"

Me.fra_Lockcurrent1 = 1
Re_lockcurrentspec1.Value = "Min"

Me.fra_Rotationspeed2 = 1
Re_rotationspeedspec2.Value = "Min"

Me.fra_Freeaircurrent2 = 1
Re_freeaircurrentspec2.Value = "Min"

Me.fra_Lockcurrent2 = 1
Re_lockcurrentspec2.Value = "Min"

End Sub

 

[Steve Sanford]

It is hard to say why with the limited info provided. I hope each control is
bound to a seperate field.

If the form row source si a query, is it updatable?

Next, let's do a little debugging. Comment out all of the lines except

Me.SpeedMode_opt = 1

Open the form. If you get an error, check the spelling of the field name,
control name, the bound field, etc.

IF there is no error, close the form, uncomment the next two lines. Open the
form. If you get the error, find out why.

If no error then continue uncommenting the next two lines and opening the
form until you get the error. Now you know which line is causing the error.

If you still can't assign value to this object, post back with what you have
found out.


HTH