I keep geting a error that says Syntax error in FROM clause. here is my code :Private Sub Data1_Reposition()
Dim strSQL As String
Dim strKey As String
If Label5.Caption = "" Then
strKey = "0"
Else
strKey = Label5.Caption
End If
strSQL = "SELECT * FROM Orders " & _
"WHERE (CustID= """ & strKey & """);"

Data2.RecordSource = strSQL
Data2.Refresh
DBGrid1.ReBind
End Sub


Thanks for any help