A
antgel
Hi all,
I have a continuous form, frmInvoiceStandalone. The footer contains some
textboxes that sum colums from the detail.
However, on loading the form to look at an existing record, the sums are not
correct. Specifically, a textbox called txtNett with ControlSource
=[carriage] + Sum([linePrice]). The other textboxes are based on this one's
value, so I guess if I fix txtNett, they'll all work.
In the example, I have four lines come up in the detail. linePrices are 5,
56, 20, and 0. Carriage is 0. txtNett shows a value of 0, but I can
confirm that if I raise the carriage value, that value will be displayed in
txtNett, i.e. it doesn't do the sum([lineprice]) bit.
Then, I go to the VBA Immediate window, and do a
form_frmInvoiceStandalone.Requery on the form. Suddenly, the totals are all
fine.
Anyone got any ideas? I can get by by putting the ReQuery line in
form_load() but it's such a kludge!
A
I have a continuous form, frmInvoiceStandalone. The footer contains some
textboxes that sum colums from the detail.
However, on loading the form to look at an existing record, the sums are not
correct. Specifically, a textbox called txtNett with ControlSource
=[carriage] + Sum([linePrice]). The other textboxes are based on this one's
value, so I guess if I fix txtNett, they'll all work.
In the example, I have four lines come up in the detail. linePrices are 5,
56, 20, and 0. Carriage is 0. txtNett shows a value of 0, but I can
confirm that if I raise the carriage value, that value will be displayed in
txtNett, i.e. it doesn't do the sum([lineprice]) bit.
Then, I go to the VBA Immediate window, and do a
form_frmInvoiceStandalone.Requery on the form. Suddenly, the totals are all
fine.
Anyone got any ideas? I can get by by putting the ReQuery line in
form_load() but it's such a kludge!
A