Referancing form in DoCmd.SearchForRecord when using Navigation form - Access

[pritesharyan]

I have a `Mainform` with `textbox` and `button` to search `subform` record
it works fine when i directly open `Mainform` and searching desire record
but when i open my form in `Navigaition` form it gives me error.

[Download My Access Project] What i have tried.
Below is my code:

Private Sub cmdSearch_Click()
    Dim MainFK As Long
    MainFK = DLookup("MainformID", "Subform", "SubformID =" & Me.txtSearch)
    DoCmd.SearchForRecord acDataForm, "Mainform", acFirst, "MainformID=" & MainFK
End Sub

Below is screen shot



Please guide me.

[June7]

Review https://www.accessforums.net/forms/t...orm-32053.html

[pritesharyan]

@June7 link you have provided is for referencing control but in my case i have to reference Form. isn't it?

[June7]

Actually, you want to reference the subform container control. I always name container controls different from the object they hold.

AFAIK, when embedding a form on a navigation control/form, have to change how the form (and therefore its controls) is referenced, even if that code is behind that embedded form.

I don't like and never use navigation form.

[pritesharyan]

Downlaod Project With Solution

PrivateSub cmdSearch_Click()

    Dim MainFK AsLong
    Dim rs As DAO.Recordset
    Dim WhereStr AsString

    MainFK = DLookup("MainformID","Subform","SubformID ="&Me.txtSearch)

    WhereStr ="MainformID="& MainFK

    WithMe.Form

        Set rs =.RecordsetClone
        rs.FindFirst WhereStr

        If _
            rs.NoMatch _
        Then

            MsgBox "Subform record not match to mainform record"

        Else

            .Bookmark = rs.Bookmark

        EndIf

    EndWith

EndSub