Cannot resolve error 2109 (1 Viewer)

[David44Coder]

A dbl-click event in Form2 should call a Sub in Form1 the close. But Access will not exceute it.
It tells me
Run—time error '2109':
There is no field named 'cboCode' in the current record.
And there's not... but why would Access be looking for it ? Should it not just follow the code instructions ?
But if click Debug I can step through perfectly and the subroutine in Form1 executes correctly'

Form2 code

Private Sub Code_DblClick(Cancel As Integer)
    Form_Form1.GotoCode (Code)  '>>>>>>>>>>> this is the line halted in yellow
    DoCmd.Close acForm, "Form2"
End Sub

Form1 code

Sub GotoCode(x)
    DoCmd.GoToControl "cboCode"
    Me!txtCode2 = x
    DoCmd.FindRecord Me![txtCode2]
End Sub

Thanks for any help with this.

 

[David44Coder]

Haha I think it may have been too dumb a question to get any answers!
Form1 was still open at the start of Sub GotoCode. So I'm passing the value via Property Let then closing Form2

 

[KitaYama]

I have not used GotoCode ever.
When I want to run a code in another form I use :

    If IsLoaded(MySecondForm) Then
        Forms(MySecondForm).SetFocus
        Forms(MySecondForm).MyFucnctionName
    End If

Of course both forms should be open. (or opened and not visible)

 

[moke123]

Why not just run the code all within form2?

Dim frm As Form
    Set frm = Forms("Form1")
    With frm

        Dim rs As DAO.Recordset
        Set rs = frm.RecordsetClone

        rs.FindFirst "YourPKValue = " &  me.SomeField    'adjust this to your needs
        If Not rs.NoMatch Then
            frm.Bookmark = rs.Bookmark
        End If

    End With

   set frm = nothing