Populate fields on one form with values from another form

[Guest]

I have a form to enter shipping information for products. When an item is
shipped, inventory must be adjusted. I've set up a command button to
automatically open the inventory form and would like it to automatically
populate like fields from the still open shipping form. How can I do this?
Thanks.

 

[Allen Browne]

This is probably a bigger question than you realize, if you are planning to
just subtract the number ordered from the quantity in stock.

What happens if a user realises they made a mistake after saving the record,
goes back and changes the quantity ordered from 100 to 10? How do you
restore the other 90?'

What happens if the user deletes an order? Do you restore those?

For a quick introduction to this issue, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

For a more detailed treatment, including a sample database you get for free
when you buy the book that explains tho to create and use it, get John L
Viescas' book "Building MS Access Applications" (Microsoft Press, 2005.)

 

[Douglas J. Steele]

Did you see that Allen offered to suggestions: one a web reference to his
excellent site, and the other a fabulous book?

Do you still have a question after those answers?