Problem with Wildcards using a Cursor

D

dberman

The query:
SELECT *
FROM tblCapitalAssets
WHERE Asset Like "C-*"

It works as a direct Access query. It works as a Record Source in a list
box. But it does not work when submitted through a cursor

With rs
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.Open query, cn1, , , adCmdText
End With

Same query without the "*" works.

Any ideas.
 
Top