<div>
Alternatively, use the after update event.
</div>


Alternatively, use the after update event.

<div>
<div class="content wysiwyg-content">
On a form I have a field named &quot;txtNewQtyShpd&quot;. &nbsp;When the user enters a value in another field on this form (&quot;txtShipQty&quot;), it gets updated. &nbsp;When the value of this field, (&quot;txtNewQtyShpd&quot;) is equal to or larger than another field named, &quot;txtOrdQty&quot;, I want a message box to appear.<br />
<br />
Here's my code but it doesn't work. &nbsp;(I've tried it in the onchange event in &quot;txtNewQtyShpd&quot;<br />
<br />
&nbsp; &nbsp; If Val(Me.txtNewQtyShpd) &gt;= Val(Me.txtOrdQty) Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox &quot;You have shipped the quantity on order. &nbsp;This order should be closed.&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; DoCmd.OpenForm &quot;frmCloseOrder&quot;<br />
&nbsp; &nbsp; End If<br />
<br />
--Steve
</div>
</div>


On a form I have a field named "txtNewQtyShpd".  When the user enters a value in another field on this form ("txtShipQty"), it gets updated.  When the value of this field, ("txtNewQtyShpd") is equal to or larger than another field named, "txtOrdQty", I want a message box to appear.

Here's my code but it doesn't work.  (I've tried it in the onchange event in "txtNewQtyShpd"

    If Val(Me.txtNewQtyShpd) >= Val(Me.txtOrdQty) Then
        MsgBox "You have shipped the quantity on order.  This order should be closed."
        DoCmd.OpenForm "frmCloseOrder"
    End If

--Steve

Can't get message box to appear

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.