SQL statement

[1000kisoen]

HI,
When running this SQL is receive an error that the FROM statement is not correct.
please advise

Private Sub cmdviewbudget_Click()
Dim db As DAO.DATABASE
Dim rs As Recordset
Dim strSQL As String

strSQL = "select ccentre,ccactuals from Query2, " & _
" WHERE Ccentre = " & Me.Ccentre

Set db = CurrentDb
Set rs = db.OpenRecordset(strSQL)

Me.viewbudget.RowSource = strSQL
Set db = Nothing
Set rs = Nothing
End Sub

gr. Kisoen

 

[Katy44]

I'm not sure, but it may be caused by the comma after Query2, I think it should be:

strSQL = "select ccentre,ccactuals from Query2 " & _
" WHERE Ccentre = " & Me.Ccentre