I have a form that has a form footer with totals
I use to use =Sum([Cost]) but this was incredibly slow.
Pleased found much faster way using recordsetclone & adding up via recordset & updating unbound text boxes, great
works well if I press a button but cannot find a way for it to work on initial loading of form.
Trying to avoid timers & such like & over the years always found a way but cannot here.
Form is based on a query in the record source as normal.
If code is in; on load or open or current etc. it errors, error not import because works fine once loaded, must be a lack of or incorrect data, actually recordsetcount shows as 3000, which is ALL the records, once query had time to operate it is in fact 20 or so records that are on the form.
Is there a way to test all data is loaded fully. I have read this many times over the years but never really been stuck with it, always with better coding or planning not been stuck.
I use to use =Sum([Cost]) but this was incredibly slow.
Pleased found much faster way using recordsetclone & adding up via recordset & updating unbound text boxes, great
works well if I press a button but cannot find a way for it to work on initial loading of form.
Trying to avoid timers & such like & over the years always found a way but cannot here.
Form is based on a query in the record source as normal.
If code is in; on load or open or current etc. it errors, error not import because works fine once loaded, must be a lack of or incorrect data, actually recordsetcount shows as 3000, which is ALL the records, once query had time to operate it is in fact 20 or so records that are on the form.
Is there a way to test all data is loaded fully. I have read this many times over the years but never really been stuck with it, always with better coding or planning not been stuck.