TrevorW
24-07-2012, 08:36 PM
:question::thanx:
I have an Access form created in 2007
a person enters an invoice total called invtot
the invoice total is then allocated against 4 cost codes called
A1,a2,a3,a4,
in the form footer I do a calculation tha adds the values of a1,a2 ... progressively after each amount is entered in a1,etc and this is totaled it a field named tota
before existing to a new record I need to check that tota agrees with invtot how do I validate this using VBA code and where would I place the code
:D
I have an Access form created in 2007
a person enters an invoice total called invtot
the invoice total is then allocated against 4 cost codes called
A1,a2,a3,a4,
in the form footer I do a calculation tha adds the values of a1,a2 ... progressively after each amount is entered in a1,etc and this is totaled it a field named tota
before existing to a new record I need to check that tota agrees with invtot how do I validate this using VBA code and where would I place the code
:D