Run time error '3075' in Access 2007

Question

I am getting the following error when I try to open a report in Access 2007. The code works fine in Access 2003.

run time error '3075'

Syntax error (missing operator) in query expression '[COUNTRY_ID]='

here is the code giving the error...

How could I fix this?

---

Private Sub List25_Click()

Combo20.SetFocus
'DoCmd.FindRecord List25.ItemData(List25.ListIndex)
Forms![Country Rate Administration].Filter = "[COUNTRY_ID]=" & List25.ItemData(List25.ListIndex)
Forms![Country Rate Administration].FilterOn = True

End Sub

---

Thansk in advance for your help!

Answer 1

I have the same problem and also the code worked fine on Access 2003. How did you solved it?