Posted 13 June 2005 - 10:19 PM
I don't know how you built your form and report, so can't be too specific at this time.
I gather from your post that the form displays all records in a continuous stream.
That can be changed.
Or, if you don't want to change, perhaps you can find on which page the record is and tell the printer to just print that page, but unless you have clear breaks between the records and specified in the properties to separate them, you might end up with pieces of surrounding records on the printed page.
You can try writing a query behind the form to display a record at a time.
That will definitely limit the printing to what you want.
Or do so in the query behind your report.
I think the bottom line is that you need to tweak the properties of the form and/or report. I don't recall the properties names at the moment, but can check in the office in a few days if your review gets you nowhere.
Did you check Access help? Look for stuff like record selection, print records, form design, etc.