Select a particular record on change/refresh

[Hfnet]

I have a form which has continuos forms view. When a person changes a record, I refresh the form to update the data, but this puts the focus back to the first record. What I want to be able to do is "follow" the record, so that the record is selected again after the refresh. I would like to do this using Me.id=..... as the reference.

 

[PaulBricker]

You can try

Me.RecordsetClone.FindFirst "[Id] = " & Me![id] & ""
Me.Refresh
Me.Bookmark = Me.RecordsetClone.Bookmark

See if that does it.

Paul

 

[PaulBricker]

On testing, I don't think the RecordsetClone method will work but I tested this and it seems to handle the situation.

Dim myVal 
myVal = Me.id
Me.Refresh
DoCmd.GoToRecord acDataForm, "FormNameHere", acGoTo, myVal

Paul

 

[Hfnet]

Thanks, in fact I had to use a combination and requery to get mine to work:

Dim myVal
Me.Recordset.FindFirst "id = " & Me!id & ""
myVal = Me.Recordset.Bookmark
Me.Requery
DoCmd.GoToRecord acDataForm, "Main", acGoTo, myVal

This works for me perfectly! Thanks again

 

[PaulBricker]

Interesting combination. Glad you worked it out.

Paul