I am revising a product sales system that contains two tables (for discussion purposes). The first table is 'orders', and the second is 'order details'.
The orders table contains an unbounded field 'sales tax', which is calculated using a second unbounded text-box that displays the subtotal. The subtotal is retrived from a summary object on appearing on the 'order details' subform (control source:
).
Because the tax rate may change, thereby affecting the validity of our database; the fact that we only collect tax from one state; and backwards compatiblity issues, I do not see how I can remove the field (tax) from the table and work on a calculated basis for my reports/queries.
I have tried to use the OnChange and AfterUpdate events of the unbounded control to write the value from the unbounded 'sales tax' to the order table's 'tax' field, but neither seem to be working. I also tried 'OnDirty' from the form, but that didn't do it either.
I have several different buttons on the form that rely upon the sales tax data (pulled from the database by the called object). While I could add a 'UpdateTax' statement to each button and again on the report's OnClose, I'm thinking/hoping that there is a better method to achive this goal.
Thanks in advance,
The orders table contains an unbounded field 'sales tax', which is calculated using a second unbounded text-box that displays the subtotal. The subtotal is retrived from a summary object on appearing on the 'order details' subform (control source:
Code:
=[<subform>].Forms![subtotal]
Because the tax rate may change, thereby affecting the validity of our database; the fact that we only collect tax from one state; and backwards compatiblity issues, I do not see how I can remove the field (tax) from the table and work on a calculated basis for my reports/queries.
I have tried to use the OnChange and AfterUpdate events of the unbounded control to write the value from the unbounded 'sales tax' to the order table's 'tax' field, but neither seem to be working. I also tried 'OnDirty' from the form, but that didn't do it either.
I have several different buttons on the form that rely upon the sales tax data (pulled from the database by the called object). While I could add a 'UpdateTax' statement to each button and again on the report's OnClose, I'm thinking/hoping that there is a better method to achive this goal.
Thanks in advance,