|
-
Aug 18th, 1999, 06:06 AM
#1
Thread Starter
Lively Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|