Bookmarks in subform

[GummowN]

I have a form which is used as a cosmetic surround for a datasheet subform. When I double click on a record a popup form is loaded where I can perform various tasks. On closing of this form the subform recalculates and takes me to the top of the list.

Is there anyway of preventing this and leaving me on the record I loaded the popup form from?

All help is appreciated

 

[kraxmo]

Your popup form must be somehow forcing a requery of the subform's underlying data.

Here is a way to reposition in Access 2K:

    'in your subform's double-click event
    Dim varBookmark As Variant

    varBookmark = Me.Bookmark
    'your popup form logic goes here
    Me.Bookmark = varBookmark

Jim Kraxberger
Developing Access solutions since 1995
jkraxberger@scp4me.com

 

[GummowN]

Thanks, that sorted it OK.

Now I just cant get the MDE to compile but that is nothing new!!!