Adjusting Quantities in a Text Box based on a Percentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have an application in which a user selects an item from a combo box and
then there is a text box in which they select the number of drops. This is
an application for create formulas of different combinations of oils. There
is always a total of 80 oils per protocol. Usually a person select about 4-5
oils. It can be as few as one and as many as about 10 but is usually about
four. It would like to create something that Allows someone to pick a coule
of oils from combo boxes and then either have it divide 80 from the number of
oils selected and then allow the user to make adjustments with an up or down
arrow. Or all the user to type in a percentage for each oil with a calculate
button and have it fill out the number of drops based on the percentage. I
am open to any ideas.

Thanks,
 
Comments inline
I have an application in which a user selects an item from a combo box and
then there is a text box in which they select the number of drops. This is
an application for create formulas of different combinations of oils. There
is always a total of 80 oils per protocol. Usually a person select about 4-5
oils. It can be as few as one and as many as about 10 but is usually about
four. It would like to create something that Allows someone to pick a coule
Click to expand...

"always 80 oils" ..... person selects 4-5, sometimes as many a 10, usually
4????

Can't be a combo box, unless you want 80 combo boxes. If there are 80 oils
*available* per protocol, of which up to 10 oils are selected, you should use
a multi-select list box.
of oils from combo boxes and then either have it divide 80 from the number of
oils selected and then allow the user to make adjustments with an up or down
Click to expand...

I don't understand the math here.
arrow. Or all the user to type in a percentage for each oil with a calculate
button and have it fill out the number of drops based on the percentage. I
am open to any ideas.
Click to expand...


Chuck, I've been looking at this for a several days, and I can't make heads
of tails of it. It would be helpful is you gave an example of what you are
trying to do. What process (on paper) that you would follow to do what you
want to do.

I'm not trying to slam you, I just can't understand what you want from your
description.
 
Steve,

Thanks for your help. Here is some more information. I have a main form
where a user plugs in a company name and a protocol name. There is then a
subform that has combo boxes. The combo boxe values come from a table called
Oils. There are about 70 or so oils in this combo box. So a user will type
in a company and a protocol and then in the subform select about 4-5 oils. I
have the subform setup as a continuous form where it will keep adding combo
boxes as you keep selecting them. In addition, there is a text box that his
along side the combo boxes called NumberDrops. A user after selecting the
four or so oils from the combo boxes will then input the number of drops for
each oil. There is always a total of 80 drops regardless of the number of
oils selected. It could be 50 drops of A, 20 drops of B, 5 drops of C and 5
drops of D. All of these values are then written to a ProtocolItems folder
that has the oil and the number of drops and a protocolID field that relates
to the protocol table from the main form. It would be nice to develop
something where a user selects a couple of oils and the default value is
80/the number of oils selected. So for four oils it would be 20. There
would then be some kind of slider arrow that allows them to adjust the number
of drops. Or some type of application where a user types in a percentage and
it calculates the number of drops. So a user picks 50 perccent and it fills
in 40 drops for A.

Any idea if there is a way to do this?

Thanks,
 
Back
Top