I
Ivor Williams
I've a form with a subform which uses as a record source a query. In the
subform is a text box named txtWorkHours which uses as a control source a
calculated field in the query.
In the footer of the subform, I've added an unbound text box. In the Data
Control Source property for the text box, I entered the following:
=Sum([txtWorkHours]).
When I open the form, instead of getting a value, I get #Error.
Please explain.
Ivor
subform is a text box named txtWorkHours which uses as a control source a
calculated field in the query.
In the footer of the subform, I've added an unbound text box. In the Data
Control Source property for the text box, I entered the following:
=Sum([txtWorkHours]).
When I open the form, instead of getting a value, I get #Error.
Please explain.
Ivor