>Sir could you help me with my adding machine in my forms. I have a combo box that stores all the products in my table then in my txtPrice is the Automated price then Theres a textbox for my quantity and last the amount. What if in one transaction entry form i have 2 products that had been bought where would i dump the next product ordered and sum all the products that had been bought in just 1 transaction. What will I use? Will I use a grid and an Add command button? Hope you could help me with this . If I use add what will be the commands to put it inside the grid and sum everything. ?
Not sure I understand the problem, but I think you can use grid with
Product Name Price Quantity Total Amount
Sugar $2.00 2 $4.00
Orange Juice $3.00 10 $30.00
--------------------------------------
Totals: 12 $34.00
(Totals are textboxes under the grid columns, assuming that grid columns are not movable and not resizable).
The other form will allow you to add items one by one and automatically would refresh the original form with a grid. That's just the first type of the interface that came to my mind.
May be others would suggest something different, also perhaps you can better state your original problem.
If it's not broken, fix it until it is.
My Blog