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
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.