If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Generate a report based on info in a form
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. |
#2
|
|||
|
|||
Generate a report based on info in a form
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 "Rebecca ATF" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Print report based on value of 2 combo boxes | Ralph Malph | Setting Up & Running Reports | 5 | February 8th, 2006 10:37 PM |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Report Based Upon Parameter Query with Form References | Vincent DeLuca | Setting Up & Running Reports | 4 | July 19th, 2004 01:55 AM |