The only thing I can suggest is requerying the calculated field. For example,
after your re-sorting in VBA coding type the following line:
YourControl.Requery
Other than that, I dont know, I'm sure someone else will respond on here
shortly...
HTH
--
Ash
Don''t forget to rate as helpful if I have helped you,Thanks!
(e-mail address removed)
Norbert Meiss said:
Unfortunately not. Any record contains a valid value. The #error appears
after resorting.
ashg657 said:
If this is a case of an empty recordset resulting in the #Error then place
the following in the control sources of your concerning objects:
Iif([HasData],Sum([Invoice]),"0.00")
HTH
--
Ash
Don''t forget to rate as helpful if I have helped you,Thanks!
(e-mail address removed)
:
Hi,
how can I avoid the appearing of #Error in the total field in a form footer.
It is a calculated field like =sum(Invoice) and shows correctly in the first
place and #Error after resorting the form.
Thanks in advance.
Norbert Meiss