TheVoiceInYourHead
New member
- Local time
- Today, 13:19
- Joined
- Mar 11, 2013
- Messages
- 4
Hey guys I am trying to do a pretty simple SELECT query but I keep getting the Enter Parameter Value pop up box, where am I going wrong in my statement?
Private Sub btnSearchMembers_Click()
sql = "SELECT * FROM Member WHERE MemberID=" & txtSearchMembers.Value & " or Surname='" & txtSearchMembers.Value & "' or Forenames='" & txtSearchMembers.Value & "';"
Me.Combo30.RowSource = sql
Me.Combo30.Requery
End Sub
I've checked all the table column names and they are correct, MemberID is an integer hence no single quotation marks.
Anyhelp would be great cheers!
Private Sub btnSearchMembers_Click()
sql = "SELECT * FROM Member WHERE MemberID=" & txtSearchMembers.Value & " or Surname='" & txtSearchMembers.Value & "' or Forenames='" & txtSearchMembers.Value & "';"
Me.Combo30.RowSource = sql
Me.Combo30.Requery
End Sub
I've checked all the table column names and they are correct, MemberID is an integer hence no single quotation marks.
Anyhelp would be great cheers!