Syntax error on WHERE clause, possible type conflict?

[shubhamgandhi]

I'm trying to run this piece of

strSQL = "SELECT * FROM ORDER_DATA WHERE ORDER=" & curOrder
rst_orderData = db.OpenRecordset(strSQL)

The ORDER column from ORDER_DATA is a double number type, and curOrder is of type double as well.

The error I'm getting points to the second line and says "Syntax error on WHERE clause".

Why do you think this is? Is it a possible type conflict?

Any help is appreciated! Thank you!

[orange]

Is that all of your vba?

You should Dim the database and the recordset.

Here's a sample just for format/syntax

Sub testSelectByDate()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("select * from Vmaintenance where Day(servicedate) = 3")
Do While Not rs.EOF
Debug.Print rs!servicedate
rs.MoveNext
Loop
Debug.Print rs.RecordCount & " Records in Month 3"
End Sub

[pbaldy]

Add this between those two:

Debug.Print strSQL

and check the VBA Immediate window for the finished SQL. Perhaps the variable doesn't contain what you think it does.

[shubhamgandhi]

No, sorry I forgot to mention this is just a snippet where the error was occuring. But I figured it out, I have to put "ORDER" in bracket as it's a reserved keyword.
Thanks for the reply tho!