Need more help on Message box PLEASE

[Kathy]

Hi. I got help writing the following code but it is not
working--need msgbox to pop up as soon as "QtyOnHand"
drops below 5. "QtyOnHand" is in a subform. I have tried
the event procedure below in both the form and
subform..the message only pops up the next ime you access
a record that has qty less than 5.

Sub Form_Currant()
If Me.QtyOnHand <5 Then
MsgBox "Inventory is less than 5", vbOKOnly,
"Low Inventory"
End If
End Sub

 

[Alphonse Giambrone]

Try the AfterUpdate event of the subform.

 

[Guest]

Thank You Al that worked.

-----Original Message-----
Try the AfterUpdate event of the subform.

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us





.