[AccessD] Form Totals and SQL Recordsets

[David Emerson]

Hi Listers,

I have an accdb which uses recordsets based on SQL stored procedures to
populate forms.

One form is set to "Continuous Forms" which has columns of numbers. In the
form footer under each column are fields for column totals.

The control source for the total fields look like this:
=Sum(Nz([SLOPSOpeningBalance],0)).

SLOPSOpeningBalance is the field name.  txtSLOPSOpeningBalance is the
control name for the records.  txtSLOPSOpeningBalanceSum is the name of the
form footer control.

The form footer control shows #Error.  The main records all show correct
values and there are no nulls.  I am converting this database from an adp
which worked fine (but the records came from the Record Source property) 

I haven't found a solution on the web for this.  The closest solutions I
have come up with is to write code to populate the totals, or to put a
subform in the Form Footer which populates the fields based on a stored
procedure which returns the totals.

Has anyone come across this before?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand