form.bookmark always returns to first record

[TTThio]

Hi,

My subform1 is using recordsetclone to make certain record become current record.

The code:

set rs = subform1.recordsetclone
rs.movelast
subform1.bookmark = rs.bookmark
msgbox "Last record"

I noticed something strange,
- subform1.bookmark set to rs.bookmark (last record),
- msgbox displayed
but soon after I clicked "OK"
- subform1.bookmark is returned to the first record.

When I applied this procedure to subform2, it worked.
Subform2.bookmark remained on the last record.

Is there something wrong with the subform? Or is it the underlying query?
What makes the procedure work in one subform and not the other, what makes the difference?

Please help....

Thanks a lot,
Tin Tin

 

[ide]

is it possible, that your Sobform1 (or your mainform) has an On Activate event procedure with a Refreshcommand?