I'm sure we could figure out something. :)

What kinds of information are we talking about? Are you saying you want to pick the patient, and then pick different types of information to go in the report, but not necessarily all of it? Can you give me some examples?

I see a patient and i have to send a follow up report to their PCP. .i have different reports in a table. I would like to make a combo box in my patient form where i can select a report and it will print with the name and date of birth of that patient to the doctor.

I also have a combo box in the same form with a list of doctors. I want to pick a doctor from the combo box and then pick a report from its combo box and be able to print a letter to that doctor.

I usually have to send out one letter to the referring PCP but sometimes I have to send it to patients referring doctor as well as their PCP.

Basically,  i want the option of choosing a doctor and choosing a report and printing it with the name, dateofbirth and the name of the doctor i am sending the letter to.

Is this too complicated??

OK, so picking a report from a list is easy. I've covered that before. Adding the patient info to that report is easy. I would recommend adding a cover page to each report, right in the report design. You could even put it in the report header. Just pull the name, DOB, and whatever else you need right from the open customer form.

=Forms!CustomerF!FirstName

In that cover page, you could also put the doctor info. That would simply be a matter of using DLookup to grab whatever info you need from the doctor table.

DoctorName = DLookup("FirstName","DoctorT","DoctorID=" & Forms!CustomerF!DoctorCombo

How are you sending these reports? Because if you're just printing them and mailing them, you wouldn't even need to edit your current reports. Just make the cover page a separate report that prints first, then print the other report. If you're emailing these as PDF files, then you could make a Subreport that you just stick in the report header of the other reports. That way if you make changes to it, it automatically updates everywhere else. I haven't done any TechHelp videos on subreports. I could add it to the list, if you'd like. I did cover them in Access Expert 9 if you're in a hurry. They work very much like subforms.

Do you understand the rest of everything else I said?