[HELP] Textbox field update from query

[janthony]

I have a Form where I can add SALES TRANSACTIONS and SUBTRANSACTIONS. The form has several textboxes calculated by a query that shows Total, Discount, Tax, and Grand Total. The problem is that whenever I enter stuff on the Form, it doesn't display/update the textboxes until you exit/reopen the form or go back/forth from another record.

The Form itself is actually designed as such:


SALES TRANSACTIONS form which includes Customer, Employee, Discount, and other information (i.e. date)
SUBTRANSACTIONS subform which displays the corresponding SUBTRANSACTIONS for that particular SALES TRANSACTION such as Product, Quantity, etc.
TOTAL subform which displays the corresponding Total, Discount, Tax, and Grand Total (from a query).

All forms are in Single Form view. Everything matches - the SALES TRANSACTIONS info, SUBTRANSACTIONS info, and TOTAL info. I just want the textfields in TOTAL to update anytime I add/change a product/quantity.

I've tried a VBA Code AfterUpdate + Me._____.requery option and that didn't work.

[Dal Jeanis]

Here's a good thread for that http://forums.databasejournal.com/sh...ate-of-subform

Here's a couple more methods:

http://social.msdn.microsoft.com/For...orum=accessdev

http://bytes.com/topic/access/answer...n-form-subform


Source: google "MS Access update main form from subform"

[janthony]

Thanks again! At this rate, I need to give you credit in my database!

[Dal Jeanis]

Nah, just click the little sherriff's star occasionally.
|
|
|
V