Update in RealTime

[Jimruns919]

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?

[Edgar]

is there a way to have it update once I assign the account code?

Use the right event for the job. How is the update query run night now? You mentioned you have to close and go back to see the changes, that sounds like something that can be fixed with Requery and AfterUpdate.

[mike60smart]

Hi you would need to Requery the Subform on the AfterUpdate of the Account Code.

[Jimruns919]

I have tried docmd.requery ([acodetotal_qry]) for the AFTER UPDATE but it fails. I even tried putting a manual requery field in and it works but then it just goes into a loop and then crashes access.

I am obviously missing something but I am not sure what.

[mike60smart]

HI

In the afterUpdate of the AccountCode use this:-

Forms![MainForm].[Subform].Form.Requery