Parameter Query

[Roger Bell]

I have a data base with a field for occupations. I have
created a parameter query and based a report on this
where the user types in the required occupation and the
report generates only those that match this occupation.
Is there any way I can have a drop down list in the
paramter query where the required Occupation can be
simply selected rather than have to type the actual
occupation and avoid spelling errors?

Thanks for any help

 

[Wayne Morgan]

No, but there is another way. You would place the drop down list (combo box)
on a form that you open in the report's Open event using the acDialog window
mode argument. This will pause the report's opening until you close or hide
the form. You would then set the parameter in the query to refer to the
combo box on the form for its value. Once the selection has been made, hide
the form so that the query can still see it and the report will resume
opening. Close the form when you close the report.