View Single Post
  #1  
Old May 19th, 2010, 08:10 AM posted to microsoft.public.access.reports
chris
external usenet poster
 
Posts: 2,039
Default Controlling printed records when report bound to multiple tables

I created a report that uses the control from a form to generate a report
based on that record's primary key. This form also has a subform which has
relationships tied to the primary key for record identification and is linked
to the main table. When preview the report the data from the subform either
does not show up in the preview when using the filter
[control]=[form]![control].[value] or makes multiple copies of the report
equal to the number of entries in the subform's table.

Is there any way around this? I have tried queries but have not found a way
to use a form's control to govern a query.

Thanks