Bookmark

[llhglhg]

I have a form, where i doubleclick on a datarecord, i want to open at form with 3 subform on, the data coms form same table, but if i use this code only data in main form is data form record set, data i subform is data from first recordset.

This is on main form

Private sub form_open(cancel as integer)
If Not IsNull(Me.OpenArgs) Then
    Dim auto As Long
    Dim rs As Object
 
 
    Set rs = Me.Recordset.Clone
    auto = Val(Me.OpenArgs)
    rs.FindFirst "[auto]=" & auto
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End If
End sub
 

On subform i use the same code, but it will not work

is there a way to make it work ?

Lars

[Seth Schrock]

Subforms don't get OpenArgs pass do them, so the first condition in your code will always be false and your code won't run. So you would need to change all your references to Me.OpenArgs to Me.Parent.OpenArgs.

By the way, when you post blocks of code, please use CODE tags.

[llhglhg]

thansk, i will remember to /code next time *S*