subform macro won't fire 1

[ThunderGeek]

I have a subform (access 2000), XP SP2 computer with two fields one named [Qty] and another named [Onhand]. A macro runs to prevent a uses from entering a quantity [qty] larger than the [Onhand] value. The macro is fired on the beforeupdate event, the conditions column is [QTY]>[ONHAND] and if this is true then a sendkey of {ESC 3} is sent. My problem is that this macro works well on all of my other computers but fails to work on my new Dell computer 1 meg ram 3 Gig Pentium. I have even tried converting the macro to code and that doesn't work either. Any thoughts would be welcome.

 

[TheAceMan1]

How are ya ThunderGeek . . .

and this in the [blue]BeforeUpdate[/blue] event of [purple]qty[/purple]:

[blue]   If Me!Qty > Me!OnHand Then
      MsgBox "Can't have Quantity greater than OnHand!"
      Cancel = True
      Me.Undo
   End If[/blue]

See Ya! . . . . . .

 

[ThunderGeek]

TheAceMan1
That fixed the problem
Thank You Very Much!
ThunderG