JuniorWoodchuck24
Registered User.
- Local time
- Today, 17:42
- Joined
- Jan 13, 2010
- Messages
- 59
I have a form that does the following:
Quantity Cost Each Total
4 2.00 8.00
3 3.00 9.00
Overall Total: 17.00
cmdGetTotal
Quantity/Cost Each/Total/Overall Total are labels
4/3/2.00/3.00/8.00/9.00/17.00 are text boxes
8.000/9.00 are AfterUpdate functions based on when quantity is entered
17.00 is obtained by hittnig cmdGetTotal (command button) that sums the totals
I also have an exit button that saves the entered data (rs.edit) into a table so you can load it back when you reenter the form.
My error is when I exit and then reenter I load the data, but if I don't modify the quantity and hit the total button it gives me an extremely big number. Is there anyway to fix this?
Thanks,
Quantity Cost Each Total
4 2.00 8.00
3 3.00 9.00
Overall Total: 17.00
cmdGetTotal
Quantity/Cost Each/Total/Overall Total are labels
4/3/2.00/3.00/8.00/9.00/17.00 are text boxes
8.000/9.00 are AfterUpdate functions based on when quantity is entered
17.00 is obtained by hittnig cmdGetTotal (command button) that sums the totals
I also have an exit button that saves the entered data (rs.edit) into a table so you can load it back when you reenter the form.
My error is when I exit and then reenter I load the data, but if I don't modify the quantity and hit the total button it gives me an extremely big number. Is there anyway to fix this?
Thanks,
