Report Filter by ComboBox

[Piddy]

Hi Everyone.



I'm trying to create a simple DB for tracking service calls. Everything is working how I want it with the exception of being able to create one report. I currently have a report called "Issues by Assigned To - Details", which shows all of the information I need.... but I want to be able to run this report one "Contact" at a time.

I'm new to Access and can't for the life of me get this to work. I'd like to have a combobox in addition to my current report screen. This is built from the Microsoft "Issue Tracker" template.

Can anyone help me out? I've attached a blank DB for reference.

Thanks!

[NTC]

Didn't look at the template. But in the most general terms. The combobox is used to define 1 record for a form. So your challenge is to define one record for your report.

One approach is to use a query as the record source of the report; and set a criteria of that query based upon the value of the combobox of the form.

Another approach is in the opening argument of the report; inspect the opening argument method/syntax - in there is an optional WHERE field that you could use; again calling the combobox's value.

Hope this helps.