Trouble with bookmark

N

nach

Dim Brec As String
Brec = Me.Bookmark
I do some other processing on table
then my instruction is
Me!Bookmark = Brec to get me back to my original row
and message I get is
MAO can't find the field bookmark refered in your expression
 
A

Allen Browne

Try:
Dim Brec As Variant
Brec = Me.Bookmark
'some other stuff
Me.Bookmark = Brec
 
Top