report based on current record in form/subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to generate a report based not on an entire query but only
on the information currently displayed on a form and its 2 subforms. The
subforms were composed with linked child & master fields to the main form.
(They display, in Datasheet View, the records contained in a subset of a
query, as determined by the current record of the query on which the parent
form is based).

So far so good, but I can't see a direct way to transfer data from these
subforms to a report, nor can I see how to associate the report with the
various (and nebulous) recordsources for the form.

Is there an example of what I'm trying to do, out there?

Thanks!
 
Hi Allen,
Maybe it's wrong but I think you should change your subform to tabular view,
then you can put a button on the subform (in detail section, of course) to
send your subform ID to the report - (or report's recordsource).
Hope this help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Move to next record on subform 2
Access 2007 conversion subforms don't display linked records 2
Move to Record in subform 5
Parameter Value error in a Subform 0
Unable to Reference a Subforms Properties/Controls 3
Populate query in a subform based on selection from combobox in main form 0
sub form & sub-subform drill down question 3

Back
Top