Form to Multiple Reports

[Guest]

Is it possible to be able to call several reports from a form? I have a main
form and a subform. When I lookup a name the subform lists names of
patients. However, these patients may require a reminder for different
procedures. I would like a command button to generate a report for vaccines,
and if there is a pt that needs to come in for a physical generate another
report for that pt. Therefore, there would be two reports for each different
patient for the same docs office. Can this be done? So far I can generate
only one report for all the pts. Thank you in advance for any help you can
provide.

 

[Guest]

You can do pretty much anything you want to in the VBA code section of the
calling form.

What I would do is check for any "required" reports there, and then generate
them programatically via the DOCMD.OPENREPORT statements.

 

[Al Campagna]

Totally,
Well, there are a lot of ways to do that, it really depends on what style would suit
your needs.

You could place 2 buttons on each record in the sub, one for VACC and one for PHYS.
But, that might take up a bit too much real estate on the form.

You could have 1 button, that when clicked, would ask the user which report they
wanted, and then open one report or the other. Either a Yes No to differentiate, or an
Input box... Enter 1 to run report 1, Enter 2 to run report 2....

Also, consider that you may need other reports for Patients later on... so a combo box
that... for example.. lists 6 possible reports for each patient. The user selects from
the combo, and that report is run.

On and on... limited only by your particular style, and subform requirements...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."