Unanswered: Next/Previous Record buttons - DAO to ADO?
I have just upgraded an MDB to ADP and I am having a few problems with some VB code I was using.
On the MDB I had some DAO code that greyed out the 'Previous record' button on the first record and the 'next record' button on the last record (Code1).
However this does not work because ADPs use ADO instead of DAO.
Also I am trying to display record numbers, which now does not work with ADO (Code2). Does anyone know how I could alter this to work on my new Access project?
Thanks a lot guys!
Dim rsClone As Recordset
Set rsClone = Me.RecordsetClone
If rsClone.Bookmarkable = True Then
rsClone.Bookmark = Me.Bookmark
cmdPrev.Enabled = Not (rsClone.BOF)
cmdNext.Enabled = Not (rsClone.EOF)