This is getting very frustrating and i need help
I am trying to use a filter on a form in access 2007 to give me the record that matches the name in the text box and this is the VB code i wrote for it
Private Sub Command17_Click()
Me.Filter = ""
Me.Filter = "Player=" & Me.Text15 (error on this line)
Me.FilterOn = True
Me.Requery
End Sub
it says there is a run-time error 3075
syntax error(missing operator) in query expression
Player = John Smith
It might be a silly mistake that i made but i need to know the answer please.
If you want me to post picks of my form i am willing to do so
I am trying to use a filter on a form in access 2007 to give me the record that matches the name in the text box and this is the VB code i wrote for it
Private Sub Command17_Click()
Me.Filter = ""
Me.Filter = "Player=" & Me.Text15 (error on this line)
Me.FilterOn = True
Me.Requery
End Sub
it says there is a run-time error 3075
syntax error(missing operator) in query expression
Player = John Smith
It might be a silly mistake that i made but i need to know the answer please.
If you want me to post picks of my form i am willing to do so