BobRosas
asked on
Rowset does not support scrolling backward.
I have Access front end and a SQL backend.
I have DAO code that I'm trying to change to ADO code.
I have the attached code snippet and I'm betting the error...
Rowset does not support scrolling backward.
Is that because my syntax is still wrong?
Thanks
I have DAO code that I'm trying to change to ADO code.
I have the attached code snippet and I'm betting the error...
Rowset does not support scrolling backward.
Is that because my syntax is still wrong?
Thanks
Set rs1 = New ADODB.Recordset
cn.Open "Provider=SQLNCLI;Server=10.0.0.10\SQLExpress;Database=FDThomasQC;Trusted_Connection=yes;"
rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn
rs1.MoveFirst
rs1.Find "[WorkReleaseId] = " & cboReleaseNo.Value 'GET ERROR HERE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Also thanks for the link. Lots of useful info.