VBA Code not working

[data808]

I changed it to:
Me.Filter = "[Genre:]='" & Me.cmbByGenre & "'"



Then I got rid of the apostrophe in 80's and now it works.

Crazy. I thought I could use any characters in the value list but I guess the computer gets confused. Anyway thanks for the quick response.

[ipisors]

I changed it to:
Me.Filter = "[Genre:]='" & Me.cmbByGenre & "'"

Then I got rid of the apostrophe in 80's and now it works.

Crazy. I thought I could use any characters in the value list but I guess the computer gets confused. Anyway thanks for the quick response.

The computer is doing exactly what its told .... with the apostrophe in 80's, until you escape that apostrophe, it becomes SQL syntax qualifier.

Any time you are building up a VBA/SQL string and the text may contain single quotes, you must code to escape those punctuation marks that you don't wish to be taken as SQL syntax.

The way to do that here will be:

Me.Filter = "[Genre:]='" & Replace(Me.cmbByGenre,"'","''") & "'"

After doing that, you can leave the single quote in the original text and it will work.
In other words anytime there exists a single quote, it gets replaced in the literal text by a DOUBLE single quote. "doubling up" is the way to escape in SQL. You'll need this frequently when you begin using .Execute methods for SQL where a user may have typed O'Donnell, for example.