Solved Run time error 3075 syntax error (missing operator)

[noaccessidea]

I'm having some trouble with this. I'm trying to set up a couple of combo boxes to filter a datasheet. I have one working but the other two do not and I can't see why. I have attached database with some sample data in, could someone take a look and let me know what I am doing wrong?

Also, how do I make the value clear from the combo box when I press the reset button?

 

[pbaldy]

Try

Me.Filter = "Student = '" & Me.cboStudentFilter & "'"

That will need to be tweaked if you have names with an apostrophe.

 

[noaccessidea]

Try

Me.Filter = "Student = '" & Me.cboStudentFilter & "'"

That will need to be tweaked if you have names with an apostrophe.

Amazing, thank you very much. That works perfectly!


Just need to figure out how to reset the filters correctly now.

 

[pbaldy]

Try reversing what you did to filter:

Me.Filter = ""
Me.FilterOn = False