bruceblack
Registered User.
- Local time
- Today, 00:23
- Joined
- Jun 30, 2017
- Messages
- 119
Hi everyone,
Ive never had this problem before and im completely at a loss of trying everything. Really need some support because its getting shameful
I have a subform with a few fields. I want to compare 2 of them and get a result.
My subform has a query as a control source.
My subform is a continuous form
My subform has 2 field (names) that i am comparing for value and if one is greater then the other, it should 'do something...
But i get NO errors, nor does my code get executed.
The fields have numbers in it, but are stored as short text.
I tried making them number fields, but still it didnt work.
I tried TEXT instead of VALUE. Still it dont work.
Why the **** does it get ignored?
Please, some help
Ive never had this problem before and im completely at a loss of trying everything. Really need some support because its getting shameful
I have a subform with a few fields. I want to compare 2 of them and get a result.
My subform has a query as a control source.
My subform is a continuous form
My subform has 2 field (names) that i am comparing for value and if one is greater then the other, it should 'do something...
But i get NO errors, nor does my code get executed.
Code:
Private Sub scanquantity_AfterUpdate()
If Me.scanquantity.value > Me.whsquantity.value Then
MsgBox "Limit exceeded"
Else
MsgBox "test"
End If
End Sub
The fields have numbers in it, but are stored as short text.
I tried making them number fields, but still it didnt work.
I tried TEXT instead of VALUE. Still it dont work.
Why the **** does it get ignored?
Please, some help