Can't Seem to identify an 'If'' failure

Hi All,

I have a slight problem. I have the code:

Please Login or Register  to view this content.

I have the first part to populate Textbox 1 with 'AUA' if the value is lower than 900. However, if the figure is between 900 and 1550 I cannot get TextBox 1 to display AUB.

You have got your inequalities mixed round, should be

Please Login or Register  to view this content.

May I suggest that you put your combo box value on the same side of the inequality each time. So change your 900 bits to

Please Login or Register  to view this content.

Good practice to have your variable first, then constant.



Edit: Additionally SELECT CASE would be suitable here since you are testing the same variable for different cases (NB: it tests the cases in the order they appear)

Please Login or Register  to view this content.