Open an Editing Form From a Split Form

[JamesJoey]

What would be the best way to open an editing form from a split form to the same record as the split form?
I don't want tom use the single record part of the split form, no editng at all on the split form.
Currently I'm displaying the record ID and clicking that using:

DoCmd.OpenForm "FormNamet", OpenArgs:=Me.RecordID

In the ON Load of the editing form I'm using:

        With Me.RecordsetClone
            .FindFirst "RecordID=" & Me.OpenArgs
            If Not .NoMatch Then
                Me.Bookmark = .Bookmark
            End If
        End With
    
    End If

 

[Ranman256]

docmd.openform "fMyForm",,,"[id]=" & txtID

 

[arnelgp]

Create a query that will filter the record based on the record id of the form:

Select * from table where RecordId=Forms! FormName!RecordID

Use this query as the record source of the edit form.

No need to code it.

 

[JamesJoey]

I forgot to mention.

I'd like to be able to move to other records in the single (editing) form.

 

[arnelgp]

Then your code will be fine.

 

[JamesJoey]

Ok.

I'm using the same approach but with a contiguous form.

Thanks,
James