Need help with Combo box value in VBA

[Faiz12]

Hello, I'm have a category field which contains either Mobile or Broadband. I want to use a combo box which has the following values: All, Mobile, Broadband. Basically I click the filter button I made and it'll filter based on the value selected in the combo box using VBA. But the problem is if I pick either Mobile or Broadband and click the filter button, it'll ask for a parameter value as you can see from the image below. It works when I picked the All option where it'll select both Mobile and Broadband. I suspect there is an issue with my VBA code concatenation.

[Micron]

your combo list bound column values are text or numbers? If text you need text delimiters. Within double quotes we use singles:

= ' " & categorySelection & " ' " (remove the extra spaces that I used to make the ' more obvious).

Also, make that Me.Combo30 (don't need .Value, but no harm using it)

Better to post code in code tags (use # on posting toolbar) and not use pics of code.