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

N

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top