"You cant assign a value to this object"

I have a form the gets values from a combo box onto the main form, what I
want to do is now get these values into the main form records:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.txt3_rate = Me.Ctl3yrlease_rate
End Sub

When I try this I get an error message:

"You cant assign a value to this object"

What is wrong with this ?

Thanks
Les

Nothing appears wrong with the code that you've posted, but obviously the
object represented by txt3_rate is not capable of being assigned a value.
Tell us more about the form's design and setup.

--

Ken Snell
MS ACCESS MVP

"LJG" wrote in message
...
I have a form the gets values from a combo box onto the main form, what I
want to do is now get these values into the main form records:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.txt3_rate = Me.Ctl3yrlease_rate
End Sub

When I try this I get an error message:

"You cant assign a value to this object"

What is wrong with this ?

Thanks
Les