Subform not displaying in report...ugh...

[jessicamosby]

I am using Access 2007



I have created a main form and have inserted a subform. When I open the main form, the subform displays correctly. However, when I go to create a Report from the main form, the subform information is not displaying.

I am not sure what is wrong. I am also not sure if this is enough information, but I am not sure what else is needed (I am a complete novice...but learning)!

Thanks everyone!

[kagoodwin13]

You can either create a report from the form, or the sub-form, but not both at the same time.

What is the process you are trying to accomplish? I'm not sure I understand your requirement right now.

[June7]

What do you mean by 'create a Report from the main form'? Reports and Forms are very different objects. I doubt embedding a continuous or datasheet form object on a report will work. A report object can be embedded on a form somewhat successfully.

Possibly you need to build a query that joins tables and use that query as the RecordSource of report. Then use report Sorting & Grouping features to organize the data.

This is really basic Access functionality and Access Help has more info on building reports.

[OTOTO]

You need to set up a query to compile the data into a single sheet and then run the report off the query.