?select query or ?parameter query - please help

[Jabez]

Hi

(I am an amateur and newcomer to this forum, I hope someone can point me in the right direction.)

I have a db that tracks patients in a cruise ship's infirmary (I'm the doctor, i.e. no programmer at all!!) At the end of each voyage I need to print 3 different logs, seperating the patients into three clinical groups.

I have fields on the "PatientVisitFORM" to define a specific cruise, and to identify the clinical group a specific patient belongs to.

I have three different queries for the three different groups which underlie the three different reports. Selecting one of the queries makes a dialogue box pop up where I can type the (rather complex) voyage number. All is working well, except I want to improve the last step: so, that, in stead of a pop up box to type in the voyage number, I want a pop up box with a drop down list where I can pick the voyage number from a list of available voyage numbers.

I can make a form with a drop down list to pick the voyage number from (that's the easy part) - but I don't know how to pass the selected value to the query on which the report is based.

Thanks for your help

 

[Jack Cowley]

In the queries Criteria use code like this:

[Forms]![FormName]![ComboBoxName]

Put a button on the same form with code to run your report. Don't close this form prior to opening the report or you will not pass the data. If the form is a Popup then you can close it from the Report if the Report is in Preview mode so the Popup is not on top of the Report. That should do it for you...

 

[Jabez]

Thanks for the help. I have tried it, and it seems to do what I need.