View Single Post
  #2  
Old April 27th, 2010, 11:51 PM posted to microsoft.public.access.forms
Tore
external usenet poster
 
Posts: 12
Default Set focus in a specific record within a subform


I guess you could use the bookmark property of your subform:

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

Save the bookmark of the subform when you have selected the record and use
it whenever you need to go back to this subform record. I guess you could
declare a string variable to hold the bookmark in the header section of the
subform vba code.

Dim StrBookmark as string
strBookMark = me.bookmark
me.bookmark = strbookmark

Bookmarks are destroyed in situations as described in the article.

Regards