MsgBox

[Kathy]

Hi, I am building an Inventory DB. On the subform I want to

 

[Ki Yi [MS]]

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