"dkintheuk" <rm*******@firenet.uk.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hmmm good plan in principle.
I changed the name of the SysAffValueAmt box from that to
txtSysAffValueAmt as menioned.
The Total box AUTOMATICALLY changed to be =Sum([txtSysAffValueAmt]) -
wierd in itself and still gave the error.
I then manually changed the sum to be as described in your post.
It still gives the same error... Damn it! this is driving me mad...
If i just make the texbox in the footer have the same field value, it
correctly shows the field value for the record i have selected in the
contiuous form but as soon as i wrap it in sum() it fails.
Any other good ideas?
I think the auto-correcting that you saw is down to a setting
Tools>Options>General Tab - Name Autocorrect. You could switch this off.
So the two textboxes and the field all have different names and it is still
playing up? Obviously, what you are attempting is pretty straight-forward
stuff, so I'm trying to think of a simple reason it might fail. What about
the field is a text field and one of the entries can't be converted to a
number?
Perhaps as a double check, create a new table tblAmount with 2 fields ID and
Amount. Create a continuous form with textboxes txtID, txtAmount and a
textbox in the footer txtTotal which =Sum([Amount]). Does this tiny sample
not work?