I put a subreport in a report so that I could show some data from another query. If I open the report that has the subreport, one of the rows of data is missing. If I open the subreport by itself, the row is there. I tried adjusting the space between the detail and Page footer, but that wasn't the problem. Anyone have any thoughts? :confused:
Thanks.

Did you link the report and the subreport? If so, you may need to unlink them.

I assume that it is linked. I used the subreport wizard. Is it automatically linked if the wizard is used?
Thanks,

Yes, it is.

Ok, I give! :) how do you unlink a subreport from a report?
Thanks,

Open the main form in design view, click on the subform container control and in the properties you should see Link Master Fields and Link Child Fields. Put your cursor in each and delete any text in those properties.

This is a subreport in a report, nothing to do with forms. I still looked in the properties of the subreport! :) I saw no mention of master or child fields. Am I missing something?

The important point in Bob's post was that you want the properties of the subreport container, not the subreport itself. Both forms and reports are the same in this regard. One way to get there is to choose the subreport with the object selector in the toolbar, then View/Properties.

Sorry for the miscommunication, but subreports/subforms are pretty much the same.

http://downloads.btlarson.com/AWF/screenshots/subreports.png

I am using MS Access 2000 and am not seeing what you have posted. I guess I have been viewing the report and subreport properties. What is and how do I view the "container" properties?
Thanks for your help. :)

Did you see this?

One way to get there is to choose the subreport with the object selector in the toolbar, then View/Properties.

I saw it, but I didn't know what the object selector is.

I may not have the formal name for it, since I just made it up, but here's a picture:

Which toolbar is that? I don't have it showing? This shouldn't be this hard! :)

Mine (also A2k) says "Formatting (Form/Report)".

Well, I left clicked the square that is in the upper left hand corner of the subreport while in design view and went to properties as I have been doing all along and finally saw what you were refering to. Can I now just see? :) I deleted the linked child and master fields as you suggested much earlier and all is well!!! Sorry to be such and idiot, but I didn't see those choices before. I sure wish I had! Thanks much for all of your help! :)

Well, I left clicked the square that is in the upper left hand corner of the subreport while in design view and went to properties as I have been doing all along and finally saw what you were refering to. Can I now just see? :) I deleted the linked child and master fields as you suggested much earlier and all is well!!! Sorry to be such and idiot, but I didn't see those choices before. I sure wish I had! Thanks much for all of your help! :)

It is sometimes hard to get to the right place, but glad you finally did. :)