calculated fields

[Webmaster@worksnotfun.com]

I no, you shouldn’t store calculated fields in a table, but rather on the
fly, but I need the data. I have a table w/3 fields tot_audits, TOT_DISCREP
& INFORMANCE (which is =1-([TOT_DISCREP]/[TOT_AUDITS]), but I can’t get it
to store in the table, from a form. I tried using the afterupdate event
Private Sub TOT_AUDITS_AfterUpdate()
Me.INCONFORMANCE = (1 - Me.TOT_DISCREP / TOT_AUDITS)
End Sub
But that doesn’t work Help

 

[Webmaster@worksnotfun.com]

Point! I've scrapped that idea.