Need a Report to Generate Based On Option Select from List or Combo Box

[ml8889]

I dont know how to write code so please bear with me. I'm using Office 2003 and creating DBs in 2000 format.

I have a database where issues are recorded and resolved. There are certain issue types such as System, Communication, General, etc., etc. I have an IssueTypetbl to update the available issue types. I also have a Maintbl that carries everything - the issue type and the comments around the issue and resolution for the record entered. (Issue Types are limited to list in the Maintbl.)

What I want to do is have a form (or report?) where I can have a drop-down list of Issue Types and according to the one chosen, a report automatically generates based on that Issue Type. The report should show only the records in the database with that issue type and the accompanying fields from the Maintbl that provides the further details of each record. Is there a way for me to do this without having to go to VB code area? What can I do? Please advise and thank you in advance.

 

[pbaldy]

A VBA method would be:

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

The OpenReport macro has the same capability if you want to avoid VBA. You can also base the report on a query with a criteria pointing to the form.

 

[ml8889]

Thanks for your reply. Does this mean the user would have to type the issue type in order to generate the report based on the parameter? I'm trying to avoid them having to type the issue type as a parameter value because they may not always know what it is. i want them to be able to select from a list or a check box or something where the values are already displayed and a report generates the same as if they typed a parameter value. How might I make that happen?

 

[pbaldy]

All 3 methods I mentioned could use a form.