Running Report filters Combo Boxes

[Ste4en]

Please help - I have used this before with one stlinkcritera but now I have 2. Something is wrong with my stlinkcriteria statement.

Private Sub Command5_Click()

Dim stlinkcriteria As String

Dim stdocname As String

stdocname = "hangList_select"
stlinkcriteria = "[umps phase]=" & Me![Combophase] And "[umps seq]=" & Me![Comboseq]
DoCmd.OpenReport stdocname, acViewPreview, , stlinkcriteria

Me![Combophase] = Null
Me![Comboseq] = Null


End Sub


Thanks

 

[WayneRyan]

Ste4en,

stlinkcriteria = "[umps phase] = " & Me![Combophase] & " And [umps seq] = " & Me![Comboseq]

Wayne

 

[Ste4en]

Thank you.