Unlogic arthemetic error

Hi,

I did a simple code on a form that generate a message when the user enter
quantity return more than the quantity sold.

The problem is that the code work correctly with some record but doesn't
work correctly with other record (the message appear if the user enter a
quantity less or more the the quantity return) and that happened when the
quantity is 10 which mean that this isn't an error in the code.

The code i am used in my project:

Please Login or Register  to view this content.

which the fourth column in list2 is quantity.

Thanks in advance......

Reema, please read through the Forum Rules so you are familiar with the Board's requirements when posting --- your VBA should always be encased within CODE tags... please edit your last post, highlight your VBA and press the # icon.

Have you tried casting the values to Doubles ?

Please Login or Register  to view this content.

For ex. "20" is < "3" in text terms.. given "2" precedes "3".