PC Review


Reply
Thread Tools Rate Thread

Controlling printed records when report bound to multiple tables

 
 
Chris
Guest
Posts: n/a
 
      19th May 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting records in a report from multiple tables =?Utf-8?B?RGF2ZU4=?= Microsoft Access 0 24th Oct 2006 06:05 PM
controlling backcolor for records in a report =?Utf-8?B?V2FyZGVu?= Microsoft Access 1 1st Jun 2006 10:29 PM
C# program with repeating records printed in Crystal report =?Utf-8?B?QWxwaGE=?= Microsoft C# .NET 2 8th Apr 2005 09:31 PM
Limit the number of records printed in a report Ty Microsoft Access Reports 1 6th Feb 2004 09:27 AM
Multiple tables printed in different sections NeoFax Microsoft Access Reports 1 23rd Jul 2003 03:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:03 AM.