jenswave25
New member
- Local time
- Today, 06:20
- Joined
- Jun 8, 2006
- Messages
- 7
Please help - cannot figure out why the search form I have keeps returning the run-time error 3131. Syntax error in FROM Clause. Everything looks good, and I have even rennamed objects in hopes that I didn't steel a naming convention. Put brackets around qrys etc. Nothing, so please anyone (a new set of eyes would be great). Below is the code line returning the error.
Private Sub btnSearch_Click()
' Update the record source
Me.frmsubSearchResults.Form.RecordSource = "SELECT * FROM [qryRecordsData] " & BuildFilter
' Requery the subform
Me.frmsubSearchResults.Requery
End Sub
Private Sub btnSearch_Click()
' Update the record source
Me.frmsubSearchResults.Form.RecordSource = "SELECT * FROM [qryRecordsData] " & BuildFilter
' Requery the subform
Me.frmsubSearchResults.Requery
End Sub