Hi,



I currently working on a simple Inventory Tracking System. I have 12 form to input and calculate balance for 12 different material. I have a form act as a main menu to go to this 12 form. In each of the 12 form I have include a trigger whereby when the event of inventory reach it lowest balance/limit a message box would prompt out telling user to order more inventory.

My Supervisor wanted a new request is when the event happen (the msg box prompt out) in the meantime the item name, date and the balance to be send to the main menu form. So whenever user open main menu form they know which inventory in need of re-ordering. Could this be done...??

I have attach my database hoping someone can guide me to finish this request. Thank You.