Bookmark og så lukke formular, hvad så

I would think so as long as the bookmark is saved in a global variable

How?~)

If you add a combo to a form you can choose to find a record on the form based on the contents of the combo.

The combo wizard creates code similar to this.


Private Sub Combo4_AfterUpdate()
    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[CategoryID] = " & Str(Nz(Me![Combo4], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub


As you can see, a recordset (rs) is used to find the record, and if it is found the forms bookmark (me.bookmark) is changed.
(If Not rs.EOF Then Me.Bookmark = rs.Bookmark)


Now because the recordset is only available when the form is opened (gets set to Nothing when its closed) then you have to put the recordset in a module so thatit doesnt get set to Nothing when the form closes. That way you have access to it all the time.

So in a module you would have

Global rs as Recordset

I get the picture!~)

Thanks