V
VBAgroupie
Hi. I have a datasheet subform contained on a main form. I would like to
show the sum total of a cost field from the datasheet subform. I've tried
putting the sum field on the main form and the subform. If it is on the main
form I get Error# in the field value. If I put it on the subform I don't see
it. What am I doing wrong? Any help is appreciated. Thanks.
Also, I have another form where i was testing for duplicate input values
(error checking). If user types in a duplicate date it takes the record to
the record that has that value, but it still looks like I've typed in a
duplicate key value. How do I get rid of this problem. Thanks again.
Natalie
show the sum total of a cost field from the datasheet subform. I've tried
putting the sum field on the main form and the subform. If it is on the main
form I get Error# in the field value. If I put it on the subform I don't see
it. What am I doing wrong? Any help is appreciated. Thanks.
Also, I have another form where i was testing for duplicate input values
(error checking). If user types in a duplicate date it takes the record to
the record that has that value, but it still looks like I've typed in a
duplicate key value. How do I get rid of this problem. Thanks again.
Natalie