Well, seems to me it actually makes sense what it is doing. There is no current record, you are creating a new record.
If you go edit that record, or any other record, when you save it the current record will remain the current record.
This might help. After the save add this code:
- me.bookmark = me.lastmodified
That should move it to the record you just added.
or if you want to return to the record you were on before you hit the add new record button:
- dim bkm as string
-
bkm = me.bookmark
-
(code to add new record here )
-
me.bookmark = bkm ' returns to the record you were at before the new record add
-
Jim