print only 1 record from the subform

[franksirvent]

Hi there
I have 1 form and subform.
The subform can have many records, all linked to the main form.
Only one subform record can be viewed at a time (I can view all the records on the subform by pressing NEXT PREVIOUS buttons)

What I need is to print the MAINFORM and the CURRENT SUBFORM record only.

I already have a report which prints the MAINFORM data plus ALL the subform data.

I want to use the same report to print just the CURRENT SUBFORM DATA (as well as the Mainform data)

I know how to get the Subform record ID number however I don´t know how to "tell" the report to only print the current subform record.

Your help is appreciated

 

[BSman]

Make the source for the report a query that combines the two tables (main and sub) and matches the current main record id and also matches the subform record ID.

You might want to create a new version of your report that doesn't use a subreport (if the current one does) and uses the query mentioned above as its record source.

 

[franksirvent]

Thanks BSMAN

From what you told me, I worked out a way...and it works!

Thanks for sending me on the right direction.