OpenRecordset Problem

[jsccorps]

ProductID is an Integer

Set rs = CurrentDb.OpenRecordset("Select * From [Inventory] Where
[ProductID]=" & Me!ProductID, dbOpenDynaset)

works fine. But when i try to add sorting, there is a problem (see below):

Set rs = CurrentDb.OpenRecordset("Select * From [Inventory] Where
[ProductID]=" & Me!ProductID ORDER BY AddDate DESC, dbOpenDynaset)

 

[Steve Sanford]

Try:

Set rs = CurrentDb.OpenRecordset("Select * From [Inventory] Where >
[ProductID]=" & Me!ProductID & " ORDER BY AddDate DESC" , dbOpenDynaset)



HTH