I am creating a Purchase Order system and everything is working but not in real-time.
So I entering: Item, qty, cost, and an AcctCode. The system is calculating the salestax and full price and this is a subform.
There is a second sub form which is consolidating the account codes and then putting the total for each account code.
Everything works, just not in real time. If I close the order then go back into, everything works but I want to have it show in real time.
The account code and total is done with an Update Query, is there a way to have it update once I assign the account code?