DrftrBob
asked on
Recordset bookmarks
This code doesn't seem change the bookmark value. I can't tell why not.
Dim State_rst As DAO.Recordset
Dim lngCountOfSourceItems As Long
Dim lngOriginatingRecord As Long ' will be a recordset bookmark
Dim i As Integer ' my record counter index
Set State_rst = CurrentDb.OpenRecordset("tblStates", dbOpenDynaset)
State_rst.MoveLast 'Makes sure count below is correct
Let lngCountOfSourceItems = State_rst.RecordCount
State_rst.MoveFirst ' Make sure to start at beginning
For i = 1 To lngCountOfSourceItems
Let lngOriginatingRecord = State_rst.Bookmark
<< do something >>
State_rst.MoveNext
Next
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER