Button Command

[JayX]

I have been creating an inventory control system for my small business. I am looking for a code that will generate to another form. So for example if I take out 4 aprons from the first row by hitting the '-1' button 4 times leaving 46 in total how do I generate the information from one form to another by hitting that submit button.

My other form shows Product ID, Date Taken, Product Description, Employee who has taken it, Amount Taken, and Total left in inventory. I need the correct information to show accordingly in the Inventory control form. Is there a code that does this? Help would be greatly appreciated...

I am attaching screen shots so you can get a visual look at what I am looking at.

[JayX]

the total amount of the aprons before hitting the '-1' button was 50.

[DanB]

You can try by first declaring a temporary variable "ProdTotal" when you open your application

TempVars.Add "tv_ProdTotal", "0"

Then, when you click on either the '+1' or '-1' buttons, increment or decrement tv_ProdTotal as needed.

cmd_Plus_1:

TempVars!tv_ProdTotal.Value = TempVars!tv_ProdTotal.Value + 1

cmd_Minus_1:

TempVars!tv_ProdTotal.Value = TempVars!tv_ProdTotal.Value - 1

When you click on Submit you Open the second form and simply copy the value of tv_ProdTotal to your 'Amount Taken' textbox then clear the value of the temporary variable:

tbx_AmountTaken.value = TempVars!tv_ProdTotal.value
TempVars!tv_ProdTotal.Value = 0