Thank you in advance for all of your patience and assistance. It is greatly
appreciated.

I know there's a way to bookmark a record in code, but for the life of me can't
remember it, nor can I find it on Google. Anyone help with this simple problem?

I want to be able to navigate away from my form, close it and when I'm done in
the open form, return to the previous form and record, instead of having to
sift through records to get back!

Michael

On 01 Aug 2004 19:05:51 GMT, lumpierbritches@aol.com (Lumpierbritches)
wrote:

Look up "Bookmark" in the help file.

However, bookmarks (presumably on the form's RecordsetClone) do not
survive closing and reopening the form. So you just save the primary
key value of your recordset in a global variable. Then when the forms
opens again, in the Form_Load event, you can find this value in the
form's recordsetclone, and set the form's bookmark equal to the
recordset's bookmark to make the form jump to that record.

-Tom.

[color=blue]
>Thank you in advance for all of your patience and assistance. It is greatly
>appreciated.
>
>I know there's a way to bookmark a record in code, but for the life of me can't
>remember it, nor can I find it on Google. Anyone help with this simple problem?
>
>I want to be able to navigate away from my form, close it and when I'm done in
>the open form, return to the previous form and record, instead of having to
>sift through records to get back!
>
>Michael[/color]