Using a combo box to filter and open a report

[Johnny Drama]

I've looked at every post I could find in the forums regarding this, and tried every thing, but I still can't get it to work and it's giving me a headache.

All I want to do is make a selection in the combo box and have it open a report filtered based upon the combo box selection.

The combo box is "Owner Name" and the form it should open is named "exceptions". The control on the report is "assigned to". One would think this is pretty straightforward, but no, not for me.

The macro assigned to after update for the combo box is set to open the exceptions form and apply the following filter, ="[Owner Name] = " & "'" & [Screen].[ActiveControl] & "'".

When I make my selection in the combo box I get a criteria selection box. If I input the exact same thing as I selected the report will open but will not be filtered. If I leave the criteria blank and select okay the report opens, but is empty.

Any help would be appreciated. I'm using Access 2007.

 

[GinaWhipp]

Does the Combo Box have multiple columns? Which column of the Combo Box is the Bound Cloumn and what is in the clumn? The Owner's Name?

 

[AccessBlaster]

Is this what you are trying to do?

 

[CBrighton]

Check out this post to see some example code of opening & filtering reports via a search form:

http://www.access-programmers.co.uk/forums/showpost.php?p=1092770&postcount=7