Hi folks,
I have searched, but not found an answer to this question.
I have a form with no 'Details' section - just half a dozen fields in the form footer all of which are SUMs of the fields in the underlying query.
The trouble is that the fields appear blank until I either click on one of them (in which case its value appears as if my magic), or I press Page Down, in which case all field values appear. I can also add a button which does a movelast, movefirst, refresh which forces all the values to appear.
I can work around this by doing the SUM in the query instead, and moving the fields into the 'Detail' Section of the form, but it's annoying me that I am missing something. Can someone tell me what I need to do to 'force' my SUM fields to update in the footer ?
Thanks very much for any help.
I have searched, but not found an answer to this question.
I have a form with no 'Details' section - just half a dozen fields in the form footer all of which are SUMs of the fields in the underlying query.
The trouble is that the fields appear blank until I either click on one of them (in which case its value appears as if my magic), or I press Page Down, in which case all field values appear. I can also add a button which does a movelast, movefirst, refresh which forces all the values to appear.
I can work around this by doing the SUM in the query instead, and moving the fields into the 'Detail' Section of the form, but it's annoying me that I am missing something. Can someone tell me what I need to do to 'force' my SUM fields to update in the footer ?
Thanks very much for any help.
