L
LMM
I have a field in the form footer of a continuous form that has the following as the control source
=Sum([curOrderTotal]
This work fine and gives the total for the column that is bound to curOrderTotal. However, here is the problem. I have a button on the form that makes chages to the underlying data by using a recordset and then calls the form's .refresh method. When the form refreshes the above mentions control displays #Error
Does anyone know what could be causing this? Thanks much.
=Sum([curOrderTotal]
This work fine and gives the total for the column that is bound to curOrderTotal. However, here is the problem. I have a button on the form that makes chages to the underlying data by using a recordset and then calls the form's .refresh method. When the form refreshes the above mentions control displays #Error
Does anyone know what could be causing this? Thanks much.