Generate a report based on info in a form

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

Guest

In my main form, my "display" field determines what is shown in an embedded
form. The embedded form's info changes based on the setting of the "display"
field. How do I generate a report that shows specified fields from the main
form and certain fields of the embedded form based on the version that is
being displayed?

I've played around, used the help menu, read different discussions, etc...
but I don't really have the technical background to take info from a
different message and see how it applies to my situation. I'm hoping someone
will be kind enough to answer my question based on my specifics. Thanks.
 
Rebecca,

You didn't provide much info, so I'll recommend 2 generalized options:
------------------------
Option 1: Single Report

Create a query based on the 2 tables to which your form and subform are
bound. When you create the query, the join between the two tables must be
changed so that you show All records from your main form's table and any
matching records from your subform's table. This query would then become
your recordsource for your report. You'll have to specify your sorting and
grouping, if any.

---------------------------------------
Option 2: Report w/ subReport (like your form/ subform arrangement)

Create 2 separate reports: 1 report based on only your Main form's table,
and 1 report based on your Subform's table. Then open the "Main" report in
design view, click on the Toolbox button on the menu bar, click the Wizard
button and then the "Subreport" button on the toolbox, and then draw a
rectangle in the detail section of your main report, and follow the
dialogue.

Hope this helps you along,
Brian
 
Back
Top