Refresh / Update Problem

I have a sizable DB that is a work in progress as I
constantly change it as time goes by. All is fine.

I have form ORDERS
a subform ORDERDETAILS bound to Orders
another subform of ORDERS called CURRENTINVENTORY
(unbound)

After updating the Field [QtyPcs] on Subform ORDERDETAILS
I want to Update/Refresh the Data on
form ORDERS
and subform CURRENTINVENTORY


I wrote the following procedure to the AfterUpdate in the
field [QtyPcs]


Private Sub QtyPcs_AfterUpdate()

Me![Quantity] = Me![QtyPcs] * Me![Weight]
Forms![Orders].Refresh
Me.Refresh

End Sub

The problem I have now is that when I enter a new Qty and
try to Tab to the next field I stay in [QtyPcs] until I
tab a second time.

I know it has to do with these 2 Refresh commands, but
I'm stuck.

I have to Refresh both forms at this point.


Thanks in advance for you help.

Stephen