dkubiak
Board Regular
- Joined
- May 17, 2004
- Messages
- 137
- Office Version
- 2013
- Platform
- Windows
I have an inventory managment database with a query that pulls up parts by part number and displays inventory levels. I would like to have a command button for "Issued" and one for "Received". A text box would pop up, and if, for example, I hit "Issued", then typed "2" into the box, then "2" would be added to my "On Hand Quantity" field automatically.
I also need to track usage data. So, when that 2 is added, I would like the 2 to be stored in a seperate data along with the part number and date.
I know I am asking a lot, so anything you can offer would be great.
I also need to track usage data. So, when that 2 is added, I would like the 2 to be stored in a seperate data along with the part number and date.
I know I am asking a lot, so anything you can offer would be great.