Return to current record after requerying form

[shezacat]

I have several data entry forms opened from various other forms. After entering a new record, the original form is updated using requery. This resets the original form to the first record. How can I requery the original form and then return to the record that was updated? I'm not a programmer, so please be explicit. Am I on the right track in thinking I need to open a recordset clone and create a bookmark?

 

[rbowes]

Assuming that the newly entered record is the last in the recordset and that you are using Access 2000, you could then go to the form's recordset's last record

Like this:

frmOriginal.Requery
frmOriginal.Recordset.MoveLast

Hope that helps.

Bob

 

[shezacat]

I should have said edit an existing record or create a new one.

 

[Rohdem]

Try this:

Dim bmk As Variant
bmk = Me.Bookmark
Me.Requery
Me.Refresh
Me.Bookmark = bmk Mike Rohde
rohdem@marshallengines.com
"If builders built buildings the way programmers wrote programs, the first woodpecker to come along would destroy civilization!"