Setvalue

[AccessComp]

Message when I try a Setvalue macro.

"The object doesn’t contain the Automation object “querysetvalue”.

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."


I am getting the above message when I tried to use the Setvalue function on a form. What can I do to set the value in two fields based on the input into a third field.

 

[MrTBC]

I think that this would do it:

Dim str As String
str = me.field1.value
me.field2.value = str
me.field3.value = str