select case not working

[Mac rod]

Yes! A really big thanks to you!!! You have been very helpful!

[Mac rod]

hi again, i think this may be a related question since its still the combo box, because when i tested it, the results where all over the place like it would say normal when it shouldn't and sometimes one text box won't display any value at all. i checked the code but it's ok the values are the way they should be. please help.

[RuralGuy]

I'm not sure what else I can do with what we have so far. Do you know how to single step the code to see what values are returned and what branches of the code are taken?

[Mac rod]

Hi!
What we have done before solves the problem that i have with the combo box. My problem now is that its not returning the correct values that i set. maybe it have something to do with the code being long and almost the same? about the single step, i don't know how to do that either.

[RuralGuy]

While looking at the code you click outside the left margin and a dot appears. That is a BreakPoint. When you run the form and execute the code, it will stop at the BreakPoint. You can then F8 a line at a time and watch the path the code takes. Hovering over variables will pop up their current value.

[Mac rod]

How will i know that its the wrong code? most of them turns yellow when i press F8.

[Mr Key]

Mac, pressing F8 helps runs the code step-by-steps, you just check the results to the end of code! Just Continue and you may know where the code is doing wrong

[Mac rod]

where do i see the results? after running the code step by steps up to the End sub nothing happens.

[RuralGuy]

Is the code that sets the other values executing?

[Mac rod]

Yes, but showing other values. like if it should be "normal" it would show "big" or "short" vice versa. And the weight textbox at first it may show for example "low" but if i again click the button it shows "big". and with some values like "60.3" it just won't show anything.

[RuralGuy]

Is the right code executing (getting highlighted)? When you hover over weight for example does it display the correct value?

[Mac rod]

Nope. It displays the value that i see in the form which is wrong.

[RuralGuy]

You lost me on that one. You enter a value in the weight control and when your code executes and you hover over the weight entry you get the "wrong" value?

[RuralGuy]

Maybe you should try and attach you db at this time. Compact and Repair and then ZIP it up first.

[Mac rod]

Yup! From the form view, the value that pops out when i clicked the results button is already wrong, that's the same value that comes when i hover in the code view. Here's my DB, I really appreciate this man.