Question Error on sum function

[stickyoil]

Hi,

I am a beginner for Access just started self-learning on it. I am trying to build a "PO system" but I faced some problems that cannot be solved...:banghead:

Problem 1
The calculation for "Total Amount" in the form "PO Details" goes wrong.

Problem 2
The "Total Amount" in the form "PO Details" cannot update by itself after I changed some data in it. I need to press "Refresh" every time.

Problem 3
Nothing can be shown in the form "POs" for "Total Amount".

I know these are some low-level problems but I sincerely hope someone can help and let me know what mistakes I have made.

Thank you very much.

 

[Uncle Gizmo]

Problem 3
Nothing can be shown in the form "POs" for "Total Amount".

Try this in Text49's control source:- =[PO Details].[Form]![Text18]

 

[JHB]

Here is the database again.

 

[stickyoil]

Thanks a lot! The problems are solved.