Call text box onExit event from another form

[beginner83]

Hi All,

I was wondering if you can call a textboxes onExit event from another form?
On my form a user enters a search criteria into a text box and when they exit the textbox the results are displayed in a listbox. This form is a subform on my main form. I want to be able to call this onExit method from the main form. Is that possible? When I put in txtSearchBox_Exit, I got an error saying Sub or Function not defined.

Thanks in advance

 

[JHB]

Is txtSearchBox_Exit public, (remove the Private in front of the procedure/sub) ?

 

[beginner83]

Is txtSearchBox_Exit public, (remove the Private in front of the procedure/sub) ?

Yeah I replaced Private with Public and I still get the error.

Public Sub txtProjectName_Exit(Cancel As Integer)
..
..
End Sub

This is where I try and call the method..

    Select Case Forms!frm_mainform!frm_search.Form.Frame0
        Case 4
            txtProjectName_Exit
    End Select

 

[James Dudden]

Try this:
FormName.txtProjectName_Exit

NB: Just replace FormName with the actual name of your form.

 

[pr2-eugin]

As I can see that txtProjectName_Exit takes in an Argument - Cancel.. So try passing that..

If it was me, I would create a Public function.. Rather than the Form's native methods.. And I would call it like..

[COLOR=Green][B]Forms("[/B][/COLOR][COLOR=Blue][B]yourFormName[/B][/COLOR][COLOR=Green][B]").[/B][/COLOR][COLOR=Blue][B]yourPublicFunctionName[/B][/COLOR][COLOR=Green][B]([/B][/COLOR][COLOR=Red][B]argumentsIfAny[/B][/COLOR][COLOR=Green][B])[/B][/COLOR]

 

[beginner83]

Try this:
FormName.txtProjectName_Exit

NB: Just replace FormName with the actual name of your form.

Worked a treat! Thanks