sub-form report

[Alice]

I am building a report from a form which is all well and good, bit my
problem comes from the subform that I have in the form that I building the
report from (is that clear!). I need to have the information contained in
the subform to be passed to the report.

To make it a bit clearer for you I shall explain the data that I pulling
in:

The main form pulls in project information (so name, code, description etc)
and the sub form pulls in benefit information based on the project code
from the main form, as in there can be many benefits to one project. But
when I try and pull this onto the report it pulls all the benefits rather
than the one for just the project I am reporting on.

thanks, Alice

 

[Philem]

Hullo! Try making a query that shows the benefits you want for a given project, which you'll provide through a prompt. When you get that working, base your report on that query, but have the query NOT ask the user through a prompt, but rather have it get the info from the form.
Make sense?
HTH
P

 

[Alice]

Thanks very much - I'm going to give it a go.
Cheers, Alice