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
|
|||
|
|||
Sub report from sub form
i have a form and a subform bound to it.
I saved the form as a report and i saw the sub report in the report itself. The problem is that no data from the sub report is shown. In the form i see the subform data. Any thoughts? Thanks in advance |
#2
|
|||
|
|||
1. Do you have recordsource in the sub report?
2. Does the Fields bound to the fields in the table? 3. How did you link the subreport to the report, If the recordsource of the sub report is Select * From Tablename Where FieldName = Forms![FormName]![Fieldname] as it was in the subform but when the report run the form is closed, it wont display any data 4. You link the Report and sub report by child and parent, check the fields, mybe its the wrong fields -- I hope that helped Good luck "Lp12" wrote: i have a form and a subform bound to it. I saved the form as a report and i saw the sub report in the report itself. The problem is that no data from the sub report is shown. In the form i see the subform data. Any thoughts? Thanks in advance |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
Is it possible to show both "Yes" and "No" answers from a "yes/no" checkbox? | Colin Foster | New Users | 28 | March 18th, 2005 02:19 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Stopping report | albertsong | Using Forms | 23 | October 22nd, 2004 04:55 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |