Hi all,

My knowledge of VBA is very minimal so please bear with me. I have a table where 1 field is the difference of 2 other fields. What I would like to do is allow the field to be updated when either the operator or operand are changed. Here's what I have so far:


lnDecl_1 = Val(Me!DECL_EAC_9_11)
lnDecl = Val(Me!DECL_EAC_23_10)
lnDelta = lnDecl - lnDecl_1
Me!Delta = Str(lnDelta)

I think I'm on the right track, but Access says I'm not. BTW, I'm using Access 95 not 97.

TIA