Populate 2nd Text box based on Value of Another

[markarmer]

I have a form which is essentially being used as a calculator...

On the form there are 2 text boxes named txtInput and txtOutput.
The basis of the boxes are to display an answer in txtOutput based on a number the user puts in txtInput...

There is no real calculation performed as I need to give a fixed answer based on what the user types in, for example:

If the user types a number between 1 and 5 in txtInput I need txtOutput to show 23
If the user types a number between 5 and 10 in txtInput I need txtOutput to show 34
If the user types a number between 12 and 20 in txtInput I need txtOutput to show 79
so on and so forth...



I need to be able to set the returned values as as I said, they can't be calculated. It will be tedious but I only need to put the values in for 35 different options so it won't be too bad, I just can't figure out how to have the txtInput use what is entered in it to pull up the right answer.

Essentially it is like an IF query, but with multiple options for the IF.

Any help with this would be greatfully appreciated, and thank you in advance.

[pbaldy]

It's certainly possible; you'd use the after update event of the input textbox, along with Select/Case. Personally though, I'd put the values in a table with 3 relevant fields: the upper and lower limits plus the value to return. Then you can use DLookup() or a recordset to retrieve the appropriate value. That makes it more maintainable than having it all in code.

[June7]

Simple If Then ElseIF Then

Me.txtInput
If Me.txtInput >= 1 And Me.txtInput < 5 Then
Me.txtOuput = 23
ElseIf Me.txtInput >= 5 And Me.txtInput < 10 Then
...
Else
...
End If

Not sure how to use Select Case with a range. Could input values be like 4.78?

[markarmer]

Unfortunately yes, the user will be inputting a number with 2 decimal places following, eq. 7.55

[pbaldy]

Not sure how to use Select Case with a range.

Case 1 To 5

[markarmer]

Thank you both...
I ended up using the select case and it does all I need for this purpose.

Thank you again

Mark

[pbaldy]

No problemo.

[June7]

Could be issue with Select Case when ranges are like 1 to 5, 5 to 10. Is this syntax inclusive of the end values? Which range does 5 belong with? That's why I asked if values could be other than whole numbers. Can't do 1 to 4, 5 to 10 because that would not capture the mixed numbers.

[pbaldy]

Only the OP can address their situation, but in your example the number 5 would get the first value (from the 1-5 test). Code will drop out of the Select/Case as soon as a condition is met, so the second (5-10) test would never be executed.