I have a form and entering an amount received or amount used from a transaction table and trying to update a balance on hand in another table. Help.I want to update the record one time.
Any suggestions?

hello,
I'm not that good in programming but I think u need to build an expression(formula using the query) to solve your problem.