By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,654 Members | 1,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,654 IT Pros & Developers. It's quick & easy.

How to capture data change...

P: n/a

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.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.