Message box

[Kathy]

Hi, I am building an Inventory DB. On the form 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

 

[Arvin Meyer]

I'd use the OnCurrent event of the form (which fires with each record
change). Create an [Event Procedure] which looks something like this
(aircode):

Sub Form_Current()
If Me.txtQtyOnHand <5 Then
MsgBox "Inventory is less than 5", vbOKOnly, "Low Inventory"
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Kathy]

Thanks Arvin..appreciate the quick response.
Kathy

-----Original Message-----
I'd use the OnCurrent event of the form (which fires with each record
change). Create an [Event Procedure] which looks something like this
(aircode):

Sub Form_Current()
If Me.txtQtyOnHand <5 Then
MsgBox "Inventory is less than 5", vbOKOnly, "Low Inventory"
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Hi, I am building an Inventory DB. On the form 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

.