Here's a quick 'n dirty Access97 (sorry, that's as modern as I've got!) database that uses an autoexec macro to open a form that has a pick list to choose from. Clicking on the button beside each name print previews a report with just the data for that name and none of the others.
The secret is building a query underneath the report that has the criterion that the Name must equal the currently chosen Name on the form, if that makes any sense. If you don't apply some kind of limiting statement like that, as the others have said, the report just goes out and gets the entire list.
Hope this helps a bit. Good luck! /forums/images/graemlins/smile.gif
P.S. You'll have to unzip the file first!
