Hi,
I have a MainForm with a Subform. On the Mainform are 3 Textboxes:
Order Qty, Qty Shipped & Qty Outstanding
Order Qty is a set figure for display purposes only
Qty Shipped is a textbox which just runs a calculation which sums a
field in each record on the Subform.
i.e., in each record on the subform, there is a textbox called
'Quantity', if there are 5 records (Shipments) on the subform and each
record shows a Quantity of 1, then the text box 'Qty Shipped' on the
mainform will show 5.
Qty Outstanding is a text box which does the following calculation:
Order Qty - Qty Shipped
So, if Order Qty = 10
Qty Shipped now shows = 5
Qty Outstanding now shows = 5
Qty Shipped & Qty Outstanding only get updated once you tab off a new
record on the subform.
The problem I have is that after I add a new record to the subform, I
want to test the value of the textbox 'Qty Outstanding' on the
mainform to see if it = 0. Qty Outstanding will only update to once I
tab onto the next record. As I am not pressing any buttons to set this
update, how can I add the record and then test the value on the
mainform ?
Appreciate your reply.
Thanks
David.