create MS Access 2007 report

[k_mohsen]

Hello



this is my first post

I create a MS access 2007 file for input our customer information. It's look like Contacts.accdb Templates, but have some more.
OK, after I inter customer info into MS Access 2007 Form, I want to print information of that customer on pre-printed papers (or registration paper forms). So, I create a blank report and put cells of the MS Access Table into specific position to meet blank spaces in registration paper forms.
Here I have two problems.
1- When I create that report and choose Preview Report Button, Report View show me three pages that first one have cells of customer info but 2th and 3th pages are blank. I create a report that fit in one page, so how can I remove 2 and 3th blank pages?
2- When I inter second and more customer info into Access Form and choose Preview Report Button, Report View show me all inputted records in 6, 9, 12 … pages. So, I have to go three last pages to find the current record. In abstract, I need to create report only for currently inputted record and not for all. How can I do that?
Thanks

[June7]

Are you using PrintPreview or ReportView? I don't know why you are see 3 'pages'. Post screen prints of the report design and results or provide db for analysis.

For item 2 you need to filter the report RecordSource. Options:
1. parameterized query, review: http://www.datapigtechnologies.com/f...mtoreport.html
2. use WHERE CONDITION argument of OpenReport, example: DoCmd.OpenReport "report name", , , "ID=" & Me.ID
I don't use option 1.