autofill textboxes

[jlabre01]

Hi,
I wanted to know if it would be possible to have a textbox where I put in a percentage (discount) and then the values (prices) in the other textboxes would be adjusted?

jlabre01

 

[boblarson]

Yes, you can put in a percent into the text box and in that percent text box's After Update event put:

Me.YourOtherTextBox = Me.YourOtherTextBox - (Me.YourOtherTextBox * Me.YourPercentageTextBox)

or if you don't enter it like .1 but as 10 (as in 10%) then

Me.YourOtherTextBox = Me.YourOtherTextBox - (Me.YourOtherTextBox * (Me.YourPercentageTextBox/100))

 

[jlabre01]

thanx a bunch