views:

34

answers:

0

I have the following code to run after another control has updated:

[Stock No].Requery

[Debug].Caption = TypeName([Stock No].Value) + " " + Str([Stock No].Value)

If (IsNumeric([Stock No].Value) And [Stock No].Value > 0) Then
    [Stock Status].Caption = "In stock"
Else
    [Stock Status].Caption = "Not in stock"
End If

The value of [Stock No] changes in the form, but [Stock No].Value does not (as seen in the debug label). How can I get the value of [Stock No]?