Storing calculation result to a control on a form

[msmithtlh]

I have a subform where the user enters multiple records. Then I have a query (1) that adds the "scores" from those records, followed by a query (2) that subtracts the total scores from 100 and stores the result to a temporary table. This part is working.



Then on the main form, I have a button to run a macro, in which I run the 2 queries. Then have a setvalue action ( I want to store the result in the temporary table to a control on the main form). No matter how I try to do this, I get an error saying that

"the object doesn't contain the Automation object TempTableName. You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations. Check the component's documentation for information on the properties and methods it makes available for Automation operations."

Please advise. Thanks.

[pbaldy]

You can't refer directly to the table if that's what you're doing. You could use a DLookup().

[msmithtlh]

Do I still use setvalue action in the macro? Would you please help me with syntax? Thanks.

[pbaldy]

If there's only one record in the table:

DLookup("FieldName", "TableName")