Identifying A Record on a form

[TKnight]

Hi, i'm trying to reference a record on a subform because when i refresh the form it jumps back to record one. I'd like a bit of VB that refreshes then jumps back to the record number that it was before. I've tried a few combinations of the Recordset and RecordsetClone but the help around these is sketchy.

Private Sub Refresh()
Dim RecordNumber as Integer
RecordNo = Me.CurrentRecord
Me.Refresh
DoCmd.Goto acDataForm, Me, acGoto, RecordNumber
End Sub

It's the Me.CurrentRecord that i can't get to work, does anyone know the right code, thanks, Tom.

 

[llkhoutx]

Use a bookmark to reposition


dim bkmk as bookmark


bkmk = me.bookmark
me.refresh
me.bookmark=bkmk