subform calculated field hidden in datasheet view

  • Thread starter Thread starter spence
  • Start date Start date
S

spence

I have an Invoice form linked to an Invoice Detail
Subform. In the subform I have a calcuated field Amount=
[Rate]*[Units]. I need to display the sum of the Amount
line items somewhere on the form, so at the suggestion of
someone on these boards I put the sum field in the footer
of the subform. Only problem is, the field won't show up
if my subform is in Datasheet view, only in Form View. I
need my subform in Datasheet view but the calcuated field
still to show up in the footer (or elsewhere if there's a
better way). Possible?

thanks,
spence
 
Spence,

One of the limitations of datasheet view is that there is no
header or footer available. What you can do is to setup your
subform so that it 'appears' to be in datasheet view when it
is really in form view by aligning all of your controls
tightly together and placing the control labels in the
subform header.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top