I am working on a datbase project at college using a DAO data control to move through a recordset(Dynaset). I am required to return (after update) to the location I am at when I add or edit a record. I set the bookmark but this does not seem to register or more precisely it always seem to register at the first record. I assume that moving through the recordset with the data control is not changing the current record. Any help would be appreciated.

Many thanks.

Is rs.AbsolutePosition able to return the info you need?

When you move through the recordset (ie: rs.MoveNext) the current record does change, likewise it does with the control.

I have used this in the delete record part of the program but can't use it on the edit or add sections. The specification calls for the recordset to be refreshed after adding/editing records which then places the new record in it's sorted position in the database. This may move the position of the original record by one.

Since I'm assuming that you have to show all the records, and just return to the one that was modified, some of my normal methods won't work.

Are you allowed to loop thru the data until you reach it?

.MoveFirst
Do until .Fields("Whatever") = ID
   .MoveNext
Loop

Many thanks for the help.

I have now solved the problem. The cause I believe being positioning the current record as the last record during the form load event (this was to obtain a record count). By positioning the current record back to the first record after obtaining the record count as if by magic bookmarks worked !

At least it's working for you now.

Never thought that could have been a problem, but then I've never been able to use .Recordcount in any of my programs. Strange how that happened.