Hi, i´ve a problem with a sql statement!!!

This is my statement:
strSQL2 = "SELECT ID,txamort,aamort FROM tbltx1987 where [ID]=" & Id
strSQL2 = strSQL2 & "order by aamort asc"

Gives me a sintaxe error '[ID]=1order by aamort asc'

I have a TextBox were i write the Id. The first string gives me all records with ID=Id, in this case 1.

Anyone can help me!!