combo box filters report

[tubar]

i have a report based on a queery. i have a form with 3 combo boxes and a button. i select info from combo boxes and hit the button...the form loads with filtered data. the on click for the button is as followed---please help me fix the code...i think it has to do with the expression of the three combo boxes

Private Sub AddDeleteEmployees_Click()
On Error GoTo Err_AddDeleteEmployees_Click
Screen.PreviousControl.SetFocus
DoCmd.OpenReport "invoice", acPreview, , "[event.id] = " & Me.[Combo2]
[client.id] = " & Me.[Combo0]"
[venue.id] = " & Me.[Combo4]"
Exit_AddDeleteEmployees_Click:
Exit Sub
Err_AddDeleteEmployees_Click:
MsgBox Err.Description
Resume Exit_AddDeleteEmployees_Click

End Sub

 

[pbaldy]

More like

DoCmd.OpenReport "invoice", acPreview, , "[event.id] = " & Me.[Combo2] & " And [client.id] = " & Me.[Combo0] & " And [venue.id] = " & Me.[Combo4]

 

[tubar]

works like a champ!!! thanks a bunch!!

 

[pbaldy]

No problemo!