Code:
Set r = Forms.Form1.Datasheet.Form.RecordsetClone
r.FindFirst "Prefix ='" & txtGoto.Text & "'"
If Not r.NoMatch Then
Forms.Form1.Datasheet.Form.Bookmark = r.Bookmark
Form_Datasheet.Form.Form_Current
End If
Set r = Nothing
The above moves to selected record in Form Datasheet. But it does not run Form_Current event.
The second to last line raises an error. I've tried different syntax but all fail.
So I suspect this is wrong - what would be the right way ?