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?
Set rs1 = New ADODB.Recordset
rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn
rs1.Find "[WorkReleaseId] = " & cboReleaseNo.Value 'GET ERROR HERE