I'm a bit confused about Bookmark.
I have the following code
I wish to show the progress through DOLoop by Bookmark, just to see what is happening. In the above this won't happen as bookmark is outside the loop. Do I need Findfirst, No Match each time? Obviously it will have found the next record with MoveNext. Is there another to show progress down the Form?
I have the following code
Code:
Set rtable = Form_Mysubform.Form.RecordsetClone
rtable.FindFirst "Prefix = '" & Prefix & "'"
If Not rtable.NoMatch Then
Form_Mysubform.Form.Bookmark = rtable.Bookmark
Do
...
rtable.MoveNext
Loop Until rtable!Year <> lstYear
End If