RE-POST...need HELP PLEASE

I followed this exactly and it works but.. the math
is not done as soon as I leave the QtyUsed field. It
updates when i go to the next record...how do I get it to
update when I leave the field?
Thanks again.
Kasey

Well, I would not put "qty used" in my table. That is a
temporary field.
It should be an unbound field on the form your users will
use for making
entries.

You will need to put code on your form in the 'after
update' event of the
'QTY USED' unbound field. This will cause the math to
happen as soon as
your cursor leaves the 'QtyUsed' field. You may decide
it would be better
to do this as you move to the next recor. In either
case, the code should
do the math, then clear the field. The code should say...


Private Sub QtyUsed_AfterUpdate()

QtyOnHand = QtyOnHand - QtyUsed

' Clear FIND Qty Used box
Me!QtyUsed.Value = ""

End Sub

Hi Kasey

Try adding the Me.Refresh as shown below.

Best regards

Maurice St-Cyr

QtyUsed_AfterUpdate()

QtyOnHand = QtyOnHand - QtyUsed

' Clear FIND Qty Used box
Me!QtyUsed.Value = ""
Me.Refresh ----- Added
End Sub

Thank You so very much Maurice...I couldn't get anyone to
respond--so glad you did.
Regards,
Kasey
-----Original Message-----
Hi Kasey

Try adding the Me.Refresh as shown below.

Best regards

Maurice St-Cyr

QtyUsed_AfterUpdate()

QtyOnHand = QtyOnHand - QtyUsed

' Clear FIND Qty Used box
Me!QtyUsed.Value = ""
Me.Refresh ----- Added
End Sub









.