Using SetValue command in a macro (1 Viewer)

[Julie4UK]

I am using Access 2000 to create a db. I need a calculation to be performed and need that stored in a field bound to a table. I was told by Microsoft, to use a macro and the SetValue command in the After Update property. I did this and it doesn't seem to do anything. I am wondering if I have the syntax correct. I want to Set the value of the [TotalHrs] control equal to the [TotHrs] control. In the "Item" field of the Macro, I am typing [Form]![Schedules]![TotalHrs] And in the "Expression" field, I am typing [Form]![Schedules]![TotalHrs]=[Form]![Schedules]![TotHrs]. Could someone tell me what I'm doing wrong.

 

[Travis]

Try this:

Item: [Forms]![Schedules]![TotalHrs]
Expression: [Forms]![Schedules]![TotHrs]

You had two things that you need to change. The first you had Form vice Forms (common mistake you don't know how many times I've done that).
The second was that you only needed to reference the value in the Expression field.

Hope this helps.