Hi I have created a table with several records in it (MS Access 2000 by the way), and a form to input and search through them. I have made a button on this form with the command to print a report, however I want to print out a report for just one record rather than the default option of all of them. Can anyone help me in my darkest hour?

I'm having a similar problem, but my program only requires one total record at a time, so I've been deleting entries after the report is done, so that each time through, there is only 1 to print anyways.

you need to make the report run off a query, then when you click you print report button, the id of the visible record gets passed to the query and the report only displays one record. [Forms]![frm_main]![id] forms or form cant rember, just woke up the above expression sits in the query and calls the id number off the selected form. that will sort it

This is probably one of the best resources for access related info around. Give it a try http://www.access-programmers.co.uk/forums/ cheers