Subject: repeating of samedata in Report generation
Posted By: anukagni Post Date: 1/18/2006 1:55:12 AM
 Hi friends,

     I got an prob while generating the report ,
 I having an report generating by front end (i.e.) by using combo box with command button Using 'OpenReport. DoCmd.OpenReport............ " . Got the Report sucessfully but the data in the report is repeating 20 - 30 times
I don't know whats is happen in the Report generating procedure.,

 Guy pls help me in this issue ,the VB code i entered in the Event procedure is :

DoCmd.OpenReport "Report", acViewPreview, , "[Issued to whom]= '" & Me.Issue_to_Whom & "'"
 
 Which give me the positive reply, But the probs is data shown in the report preview & in the print-out is one data is repeating 20-30 times
  thanks in advance
bye,
Pap

Reply By: AccessMaster Reply Date: 1/21/2006 2:32:34 AM
The problem is probably in the report's record source.

Sounds like you are using a query with multiple tables that are either not joined or the join is generating a "many to many" relationship.

I woudl first verify the report's record source is working properly..

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Go to topic 38823

Return to index page 472
Return to index page 471
Return to index page 470
Return to index page 469
Return to index page 468
Return to index page 467
Return to index page 466
Return to index page 465
Return to index page 464
Return to index page 463