P
Phil
I have asked this question before, but it is now starting to bug me. I have
a Switchboard with a subform the sub form has one text field with the term
=Sum([RegistrationFee]) this gives me the total of how much has been made so
far. this does work however on opening the database the subform is blank, if
i hover the mousepionter over the subform the calculation appears as if by
magic!! i have tried not using a subform and placed it in a textbox with the
control source =Sum([Registration Query1]![RegistrationFee]) this only
produces an error. the subform at least produces the correct answer. i am
relatively new to Access and cannot see why this does not work
a Switchboard with a subform the sub form has one text field with the term
=Sum([RegistrationFee]) this gives me the total of how much has been made so
far. this does work however on opening the database the subform is blank, if
i hover the mousepionter over the subform the calculation appears as if by
magic!! i have tried not using a subform and placed it in a textbox with the
control source =Sum([Registration Query1]![RegistrationFee]) this only
produces an error. the subform at least produces the correct answer. i am
relatively new to Access and cannot see why this does not work