Message box

  • Thread starter Thread starter Kathy
  • Start date Start date
K

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
 
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
 
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
Click to expand...


.
Click to expand...
 
Back
Top