Report from form/subform?

[Jar80]

How to make report from form which contains subform?

 

[Cretin]

Wouldn't you actually want to report off of the data in a table. The form is only an input device to a table.

You can either report directly off of the table or create a qyery and generate the proper data from that query and use that in the report.

Cretin

 

[Jar80]

I have try using tables and queries but, it is too complicated to access i guess.

It just not open the querie or report when it has two tables in it.

 

[Jar80]

Now it´s work but there are another problem.
In form where I have made button, which opens a report,
is doing this it opens the report but it opens all records, while it should open only the current record, how I´m able to filter that the report shows only the current record which is entered on current form.
I believe that there is a macro that should do "open record"
which has the fields "filter" and "where"
but what I should enter there?
Hopefully this question is clear, ask for details if not

Thanks

 

[PHV]

Take a look at the 4th argument of the DoCmd.OpenReport method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244