Cannot get report to open with WHERE clause that references combo box

[handlebars]

I have used the following code:

On Error GoTo Err_Command2_Click

Dim stDocName As String

stDocName = "OutstandingCalls"

If IsNull(Me.Combo0) Then
DoCmd.OpenReport stDocName, acPreview

Else

DoCmd.OpenReport "OutstandingCalls", View:=acViewPreview, _
WhereCondition:="sys_assignedto=" & Me!Combo0

End If

But when i run my report i get all the records even when i have selected a value from my combo box.

Can anyone point out why this does not work - am i missing something really simple??

Any help would be appreciated.

Andrew

 

[cmmrfrds]

Does your report have filteron = true?
Are you sure you are taking the path with the filter - debug statement to see.