Runtime error 80020009 - can't assign a value

[addy]

OK

I have a subform which is a continuous form and has 3 fields in it which are unbound text boxes which are used to calculate financial values using various information from the subform itself plus other tables.

What i want to do is save these calculated values into a table, so what i thought I would do is add the necessary fields to the table, add these fields to the subform as hidden text boxes and then on the Form Unload event, write the values of the calculated controls into these hidden text boxes.

However, when I try this I get the following error message:

Run-time error '-2147352567(80020009)'
You can't assign a value to this object.

Any ideas? This has really got me stumped.

 

[BuilderSpec]

Can you assign a value to the other objects ?

Is the sub form based on a query ? If so is it an updateable query.



Hope this helps!

Regards

BuilderSpec

 

[addy]

OK

I think the problem was that it was a continuous form. I have modified my coding to loop through each record and assign the relevant value to each occurence of the text box.

This seems to work fine now.