Hi, I am building an Inventory DB. On the subform I want to
> have a message pop-up when the QtyOnHand drops below 5
> pieces. Whats the best approach for doing this. Any help
> is very much appreciated.
> Regards,
> Kathy
Ki Yi [MS] - 13 Aug 2004 19:20 GMT
Hello,
You try adding code in Oncurrent and Onopen event of a form that will check
that particular field and
if it's < 5 and display a message box.
For example,
If me.field1 < 5 then
msgbox "item low"
End if
Hope this helps!
Ki