Pop up Message after click Submit Button (1 Viewer)

[Bandara]

I have two tables
1.Product (PID,QTY_Balance)
2.Add Product (RefeNo,PID,Amount)

I created Form to Add Product Table. Also Create query to update QTY_Balance by in relevant product after add products by forms. Query Also Working No Issue.

Now I want to Pop up Message "Your Balance is [QTY_Balance ]Field By relevent PID after click submit button. It shoud be the updated record. How to Create It?

 

[Minty]

You should always calculate the balance qty from your usage, trying to maintain it as a separate field is fraught with difficulties.
Have a read here : http://allenbrowne.com/AppInventory.html