G
Guest
I have 5 fields in my DB (Customer, Legal, Date, Margin, and Net Charge). All
fields but the Net Charge I want saved to the DB as Net Charge will be
constantly changing per form. Through a query the user can pull up data by a
certain criteria whether its a date range, or a customers name. On the form
will be multiple records depending on the criteria of the user. Now the user
might input +500 in the 'Net Charge' box of the first record, and +300 in the
next record. What I need to happen (not even sure how to start this one code
wise) is when the form is closed all data in every Net Charge box is set back
to 0. I can get the text box of the current record to switch (
Net_Charge.text = "0"), but I am at a loss as to get all the Net Charge boxes
on the form to zero out. Any help would be greatly appreciated.
C_Ascheman
fields but the Net Charge I want saved to the DB as Net Charge will be
constantly changing per form. Through a query the user can pull up data by a
certain criteria whether its a date range, or a customers name. On the form
will be multiple records depending on the criteria of the user. Now the user
might input +500 in the 'Net Charge' box of the first record, and +300 in the
next record. What I need to happen (not even sure how to start this one code
wise) is when the form is closed all data in every Net Charge box is set back
to 0. I can get the text box of the current record to switch (
Net_Charge.text = "0"), but I am at a loss as to get all the Net Charge boxes
on the form to zero out. Any help would be greatly appreciated.
C_Ascheman