S
Stephen
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
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