Exit do at Bookmark

[speakers_86]

How can I exit a Do Until when the recordset reaches the bookmark? I've tried stuff like this

Do Until varbookmark=rs.bookmark

But it gives a type mismatch???

 

[Kafrin]

Could do with a bit more info for this.

If it's a type mismatch that implies that Access isn't recognising your variable as a bookmark. Do you have a line before your "Do":

Dim varbookmark As Bookmark

...and also a line setting varbookmark to a valid bookmark?