Interdependable Text Box

[Skarvion]

Hi, this is my first post in this forum, looking forward getting to know more about access.

So I've made a form for transaction. Say there's a Price textboxt that shows the price of the selected item from another combo box. And then there are 2 textboxes for discount, a PercentDiscount textbox that allow the user to deduct the price in percentage form and the FixedDiscount that allows them to deduct in a fixed number.
These 2 discount textboxes dependent on each other. For example if the price is $100, then when the PercentageDiscount is 10%, the fixed discount is automatically shows $10 and vice versa.

Although I did managed it to work with VBA using LostFocus event in each of the textboxes, it's not foolproof. If for example the Price of the item in question is changed from the combo box, the discount textboxes stays the same.



Is there any workaround for this to gurantee the discount is always updated? Thanks in advance

[RuralGuy]

You need a Function that updates all of the TextBoxes and then call this function from the After Update event of all of the TextBoxes.

[CJ_London]

in your percentdiscount control after update event you put

me.fixeddiscount=me.PercentDiscount*price

in your fixeddiscount control after update event you put

me.PercentDiscount=me.fixeddiscount/price

in your price control after update event you put

percentdiscount_afterupdate

which will recalculate the fixed discount. If on the other hand you want the fixed discount to remain the same and recalculate the percentage (clearly you can only do one or the other) you put

fixeddiscount_afterupdate

calling the sub just means you are reusing the code - if at some point in the future you wanted to change the calculation, you only have to do it in one place

[Skarvion]

in your percentdiscount control after update event you put

me.fixeddiscount=me.PercentDiscount*price

in your fixeddiscount control after update event you put

me.PercentDiscount=me.fixeddiscount/price

in your price control after update event you put

percentdiscount_afterupdate

which will recalculate the fixed discount. If on the other hand you want the fixed discount to remain the same and recalculate the percentage (clearly you can only do one or the other) you put

fixeddiscount_afterupdate

calling the sub just means you are reusing the code - if at some point in the future you wanted to change the calculation, you only have to do it in one place

Hi Ajax, thanks for the reply. It worked perfectly.