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

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