"RecordSet is not updatable"

[ilcaa72]

i am using VBA and recordset method to fill a textbox in my form.

it was 'bound' to a table which i removed and got a different message... "cant assign a value to this object"


anyone share the rules for using VBA to change values of controls on a form.
thanks

 

[sneuberg]

Check the control source of the control to make sure their nothing in it.

 

[Ranman256]

some recordsets are not updateable, due to the joins.