Input and return values

[Guest]

I'm a newby and I cannot find how to complete this action.
I am working on a program that will allow input of a value "1" and return a
value of "walking" or whatever value.
The input value is in a combo box with other values "1, 2, 3, ..." and with
each will return diff values in another display box. Any ideas on how to
produce these results?

 

[Guest]

Hi Tony -- In the AfterUpdate event of the combo box, use a case statement to
update the value of the display textbox:

Select Case cboComboBox.Value
Case 1
txtDisplayBox = "Walking"
Case 2
etc.
End Select

However, what exactly are you trying to accomplish? Why not just have the
value displayed in the combo box?

 

[Guest]

Thanks for the info. I am trying to create a program for site evaluations for
the health department. for example the amount of bedrooms in a house for
input will have an out put of the size of the septic tank for the septic
system. The same for landscape postion, soil types and other factors. All
these factors will be put to one list that will be the output for that
particular septic system.

 

[Guest]

Interesting. I was asking because by the question, it seemed as if you may
have some duplicate features or unnecessary fields. However, I hope it works
out for you. If you need additional help, post back. Good luck.