value & percentage

[r]

I have a subform that allows the user to set budget amounts for each service
that will be used for a specific job. The user wants to enter either a
dollar amount and have the % of total budget be calculated OR enter the
percentage amount and have it calculate the dollar amount.

What would be the best way to go about this??

Suggestions are greatly appreciate.

Thanks in advance.

 

[Guest]

Hi R,

I was once in this kind of situation so here is what I did, next to the text
box I placed a combo box from which the user could select if the figure
entered in the textbox was Rs in amount or was it %, it had only two option,
so based on what the user selected I used two different formulas to do my
calcualtion. In another situation where the user had to have a standard
additions and as well as his own additions and subtraction. Wha he wanted was
teh some of the additions would be deductions at times, so I put a combox
from which the user could selct if the amout was to be added or subtracted,
and depending upon the selection subtract the amout or add the amount.

Hope you find it useful too.

Anand