The form moves to the first record after changing a record and saving the change

[odrap]

After changing one or more fields of a record on a form, the form shows the first record.
I want to stay on the record that has been changed.
When the button "Change" is clicked, in the event that is fired
the bookmark of the current record is saved: Bladwijzer = Me.Bookmark.
( Bladwijzer is declared as a variant ).
After the changings are done, the button "Save" is clicked. In this event i use : "Me.bookmark = bladwijzer" to stay on the same record.
However , that seems not to work.
What to do to stay on the same record?

 

[pbaldy]

Not sure exactly what you're doing in your code, but it sounds like this may be applicable:

http://www.baldyweb.com/Requery.htm

 

[SOS]

Just a quick note - using the bookmark method can fail if you add or delete records. I would use a find instead using the primary key of the recordsource. But that's just my preference.