Cross form search

[Kaosu]

I would like to know how to do a search in a text box on Form X that closes Form X and opens Form Y and looks for the information in Y.

The search works perfectly when preformed while on Form Y. The search box is identical on both X and Y, its just getting X to point at Y when executing this command.

    Dim strFilter As String
    strFilter = ""
    If IsNull(Me!fnSRH) Then
        strFilter = strFilter
    Else
        If strFilter = "" Then
            strFilter = strFilter & "FullName Like '*" & Me!fnSRH & "*'"
        Else
            strFilter = strFilter & " AND FullName Like '*" & Me!fnSRH & "*'"
 
    End If
    End If
 
    Me.Filter = strFilter
    Me.FilterOn = True
    Me!fnSRH = Null
 

[Lysander]

Not 100% certain what you are trying to do, but this may help.

At the end of your code you say me.filter=strFilter. I assume you want this on Form X.

so try this.

DoCmd.OpenForm "formy", , , , , , strFilter
 
 

and then in FormY OnOpen event

DoCmd.Close acForm, "FormX"
me.filter=openargs