S
SteveInBeloit
Hi,
I have a subform on a main form based on a stored procedure. In the main
form, I set the record source to the stored proc, and the input parameters to
the paramters. In the form footer of the sub form, I have two controls, both
with sum's. ex. =SUM([field1])
On the sub form, I have buttons that when clicked, reset the record source
and input paratmeters of the subform and do a requery. The first time in,
all is good. The detail is good, and the two sum fields are correct. When I
hit one of the buttons, the new data comes up, but in the two sum fields, I
get #Error.
Any thoughts?
I have a subform on a main form based on a stored procedure. In the main
form, I set the record source to the stored proc, and the input parameters to
the paramters. In the form footer of the sub form, I have two controls, both
with sum's. ex. =SUM([field1])
On the sub form, I have buttons that when clicked, reset the record source
and input paratmeters of the subform and do a requery. The first time in,
all is good. The detail is good, and the two sum fields are correct. When I
hit one of the buttons, the new data comes up, but in the two sum fields, I
get #Error.
Any thoughts?