My BALANCE field is not being saved
Posted on 2003-03-30
Hello and thanks for the assistance -
I have three Access fields:
The control field for the VisitBalance is =[VisitCost]-[VisitPayments], which gives me the difference between the two fields. The problem is that the VisitBalance isn't saved, so I can't run reports off of my VisitBalance field.
I know the problem is because I'm using =[VisitCost]-[VisitPayments] in the control field.
How can I do the following:
* Get the difference between my VisitCost and VisitPayments field to default on my FORM and
* Store the difference in my VisitBalance field for reports
Any help is appreciated - thanks
Note: I tried putting =[VisitCost]-[VisitPayments] as a default on the VisitBalance field, but it didn't work for me.