HI
I am creating a report from a current record which has sub forms in the main form. Please could you give me the access path i have to put in the report to allow the data to be accessed from the subform
Thanks in advance
Karl:)

Exhibitor,
I think first of all we should translate ur question to an access language.
Are u saying that u are creating a report from a form with subform ? Ok, what
would u mean saying: "allow the data to be accessed from the subform"?
Would that mean u want the data on the subform to be on the report ? Ok, if
that is the case try using the report wizard.
Rgds Penta

Hi,

   You will probably need to create a query that duplicates the structure of the form/subform. Then use the report wizard. Alternatively, use the report wizard to do the whole thing, but this can be problematic.

   You can also pass parameters to your underlying query from the form/subform.

HTH


mmcdonal

I have found on the microsoft web site Article ID 209099

How to refer to a control on a subform or subreport in access 2000

it shows this code

forms![main form name]![subform control name].form![control name]

when i put this in a report it puts [] around the word forms and form.

but it only producers a #name? on the report

can any one help?

See my topic "reaching a subform through code". I've escaped the problem by
having the form and subform related by a wizard form link solution. So u will
call form and subform as forms. Although Randall suggested a solution to the
first problem which i'll have to try further.
Hope that help,
Penta:)