Not a valid bookmark error
Posted on 2007-12-03
I have created recordset RecipesRS and would like to bookmark the record previous to the one showing on the unbound form:
Dim varBookmark As Variant
Set RecipesRS = db.OpenRecordset("SELECT " & strTableName & ".* FROM " & strTableName & " ORDER BY " & strTableName & ".txtCourse;", dbOpenDynaset)
'The user can scrolll through the recordset in a form.
'This is the part that doesn't work:
varBookmark = RecipesRS.Bookmark
I get run-time error '3159': Not a valid bookmark.
Does anyone know what I'm doing wrong?