Getting data from a subform to appear on a report

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hey everyone,
here's my latest struggle. I have a report that gets all of
it's fields filled up off of a form. that form in turn has
a subform. that subform has two textboxes on it, but is in
datasheet view, so you can see multiple rows. I need to
know how to get all of those rows into my report. the
number of rows on that subform will vary between records.
i've tried setting up a textbox in my report, where the
control source is an SQL statement, or one that is a query.
Each time I get a prompt to enter data into an input box
(which is nothing that I coded). I've tried to tell the
textbox on the report to do a lookup according to the
record's number, from the table that supplied data to the
subform, but I get a "?#name" thing in my report. Any one
have an idea how to accomplish this?
 
Try looking at the subreport properties where the link
child and link master field settings are. You have to
select the entire subreport not the little box in the
upper left corner of the subreport design view, to see
these properties. In other words, the subreport
properties and the subreport detail and header properties
are separated this way.

Hope this helps
Eric
 
currently, I do not have a subreport on my report, just a
subform on my main form. do i need one in order for this
to work properly?
 
Back
Top