Printing reports in batches

[mnsemple83]

I created a form that is used to print reports based on data supplied by the user. What I want to do now is to allow the user to select several patients at one time and a specific date value. This will allow the user to view patient records with regards to a specific date.



What I thought would work is if I use a list box for the patient's unique identifier (their MRN), allow the selection of multiple values, then supply a date value and that would work. Unfortunately, the only thing I got was a page containing only basic information about one patient (MRN, first name, last name, zip, gender, and age) and everything else was blank. I think that I am on to something, but if anybody has any suggestions on how I can solve this problem, I welcome it.

[pbaldy]

Here's an example of how to use a multi-select listbox to filter a report:

http://www.baldyweb.com/multiselect.htm

[mnsemple83]

I used the code that was supplied to me and it worked. Thanks.

[mnsemple83]

Now that I am able to print report in batches, I need to come up with a way so that the list box only allows me to select patients who have been visited on the date supplied inside the same form. Once the date has been entered, the list box should have been filtered only to include patients with visits on that date. Is there a way to do this as well?

[pbaldy]

Sure; you have what is in essence the same as a cascading combo box:

Baldy-Cascading Combos

in that you want the selections in the list to be dependent on the date. You can use either of the techniques in that link, but using the after update event of your date textbox instead of a combo.

[mnsemple83]

In the form, the date field is an unbound text box and the patient's MRN is a combo box that comes from a JOIN query with the Patient's table and the Encounter's table. They both share the MRN value and the "DateOfVisit" field from the Encounter's table is used in the query to compare the value in the form.

I tried using the second technique because it seemed more appropriate for my form but it didn't return anything. I can't find anything wrong with the code I had written so I do not know where my error is.

[pbaldy]

I do not know where my error is.

Not having seen your code, neither do I.