After Update help please

[Babbabooie]

Newbie.....



I have [cancelled] as a yes/no field
I have [cost] as a currency field

if someone updates cancelled (checks the box) i would like the cost to become 0


If [Cancelled]<> 0 Then

EditRecord
Alias EraseCost
SetField
Name ZeroCost
Value = [tblone].[cost] = 0
End EditRecord

Any help is appreciated!!

Thanks

[ItsMe]

If you have a control bound to the "cost" field, you can reference the field via the control's name

Me.cost.value = 0