Syntax help 1

[atadbitslow]

Set rst = dbs.OpenRecordset("SELECT * FROM res WHERE [ID]=' & Me.ID order by [year_res] desc&quot

Can someone help me get this syntax right, I've tried so many different variations! Thanks-

 

[JohnLowell]

Try this:

Set rst = dbs.OpenRecordset("SELECT * FROM res WHERE [ID]= " & chr(34) & Me.ID & chr(34) & " Order By [year_res] Desc&quot

 

[atadbitslow]

Thanks, but I got an error:

"Data type mismatch in criteria expression"

The field ID is a number field--

 

[JohnLowell]

Then try this:

Set rst = dbs.OpenRecordset("SELECT * FROM res WHERE [ID]= " & Me.ID & " Order By [year_res] Desc&quot

 

[atadbitslow]

That worked! Thanks a bunch!!