Need help with Apply filter based on 2 comboboxes

[reggiete]

Could anyone help with the code below, i get a error after the And, which im sure i have the syntax wrong


Me.Filter = "[Assigned Analyst] = '" & Me.UserQueueSelected & "'" And "[Testing Month] = '" & Me.Testing_Month & ""


Both combo boxes are text strings

 

[JHB]

Try the below, (I've add one ' and removed 2 ")

Me.Filter = "[Assigned Analyst] = '" & Me.UserQueueSelected &  "[B][COLOR=Red]'[/COLOR][/B] And [B][COLOR=Red][[/COLOR][/B]Testing Month] = '" & Me.Testing_Month & "[B][COLOR=Red]'[/COLOR][/B]"

 

[reggiete]

thank you for your help, i knew it was something with "