G
Guest
I am having problems with the bookmark failing in a subform due to "No
current record". This only happens when I set a bookmark in the subform and
return to it. Then requery the subform and try to set another bookmark at
the same location.
The only thing that I found that will fix the problem is if I go into the
subform and use the cursor to select several records. I can then go back the
original record and the bookmark will work.
I use the following statements to set and return to the bookmark.
BMK = Recordset.Bookmark ' set book mark
'perform action on records. Note: it doesn't matter what actions I perform
the problem will occur regardless of whether these steps are here.
Recordset.Bookmark = BMK ' return to bookmark
I then use the following statement to requery the form for a different
recordset.
Forms!SCHEDULE.Child26.Requery 'Child 26 is the subform in question
When I try to reset the bookmark in the same location in the subform I get a
message that there is "No current record". This seems odd since I am using
an afterupdate on the form to trigger setting the bookmark. Consquently,
there must be a current record.
Please help!
current record". This only happens when I set a bookmark in the subform and
return to it. Then requery the subform and try to set another bookmark at
the same location.
The only thing that I found that will fix the problem is if I go into the
subform and use the cursor to select several records. I can then go back the
original record and the bookmark will work.
I use the following statements to set and return to the bookmark.
BMK = Recordset.Bookmark ' set book mark
'perform action on records. Note: it doesn't matter what actions I perform
the problem will occur regardless of whether these steps are here.
Recordset.Bookmark = BMK ' return to bookmark
I then use the following statement to requery the form for a different
recordset.
Forms!SCHEDULE.Child26.Requery 'Child 26 is the subform in question
When I try to reset the bookmark in the same location in the subform I get a
message that there is "No current record". This seems odd since I am using
an afterupdate on the form to trigger setting the bookmark. Consquently,
there must be a current record.
Please help!