Transferring data to a second form

[JayX]

I have created a database that deals with inventory control. My next step that I have been approaching is to click a command button that opens up a separate from but takes specific information from FORM 1 into the new FORM that I just created.



So if a specific Employee takes out 4 aprons from a total of 50 and there are now 46 left, I would like the submit button to transfer that data over accordingly to Inventory control form in the correct text boxes.

Specific Example: If employee John Doe takes 4 aprons from a total of 50 which now leaves 46 how can I transfer that data into the other form showing specific information like 'Product ID' taken, 'Date' it was taken, 'Product Description', 'Employee' who took it, 'Amount Taken' and, 'total' left. I need the extended information to show up in the text boxes on form 2.

Is there a certain code that does this? Here are screen shots so you can get a visual

Please Help....

[JayX]

The name of my first form is 'Inventory Details' where I want to transfer my data to form 2 named 'Employee Information'.

[orange]

The general approach to this issue is to use a transaction table. When something is taken from Inventory, identify all the pertinent info and record it in a transaction record.
To find current quantity in Inventory, use the transaction records to calculate it.
Additions to inventory are Plus (+) transactions, removal/withdrawal from Inventory are Minus(-) transactions.