Can anyone tell me how to get specific data from my forms (e.g print off one persons name to all of his reports)without printing off everything on the database? help will be appreciated as I dont have much hair left!!

Use the 'Where' section of the Docmd.OpenReport

See the help file for more information.