A problem with the multiple search

[zozo.zead]

I created a MultiSearch form to perform a general search for outgoing and incoming books

When selecting any of the fields in the form and choosing the type of book (outgoing or importing),

It displays the results through one of the two forms, MultiSearchward or MultiSearchsadr, depending on the type of book



But it didn't work

https://top4top.io/downloadf-2830tjbbh1-zip.html

[June7]

What does "didn't work" mean - error message, wrong result, nothing happens?

Many will not download from external site. Follow instructions at bottom of my post to attach file.

If your db is in Arabic, might not be able to understand it well enough to debug anyway.

Review this tutorial http://allenbrowne.com/ser-62.html

[zozo.zead]

What does "didn't work" mean - error message, wrong result, nothing happens?

Many will not download from external site. Follow instructions at bottom of my post to attach file.

If your db is in Arabic, might not be able to understand it well enough to debug anyway.

Review this tutorial http://allenbrowne.com/ser-62.html

no result and nothing happens

[Bob Fitz]

no result and nothing happens

Have you tried stepping through the code at run time and examining the values there at run-time.

[Welshgasman]

Bob,
There is no code, all in queries with reference to form controls.
Arabic as well, so none of the form controls mean anything to me whatsoever. :-)

[Bob Fitz]

Bob,
There is no code, all in queries with reference to form controls.
Arabic as well, so none of the form controls mean anything to me whatsoever. :-)

Actually, I found some code for the large button at the bottom of the form called "MultiSearch".
I think it is supposed to interrogate the value of the combo at the top of the form and then open one of the other two forms but vba doesn't seem to be able to read the Arabic words that are returned from the ValueList in the combo but I don't know if that more to do with my setup being in English rather than Arabic . Also, the db doesn't seem to be normalised since the two values in the combo's value list appear in the table called "informations" several times. In the attached db I have added a table "tblKindBook" and changed the text field in "informations" to a number field with appropriate values, I think.
I have changed the Row Source property etc to use the new table "tblKindBook". I have also Made some changes to the form called "MultiSearchSadr" because of the changes made to "informations". I have not made similar changes to the form called "MultiSearchWard". I'll let the OP have a go at that.
At least those changes allow the user to get one of the search forms to open, if, indeed, that was the actual problem. My ignorance of Arabic prohibits me from doing much else. What I've done already, may even be totally incorrect.

[zozo.zead]

I have changed all fields to English
Information table
Two tables for incoming and outgoing

Required in multiple search form
When you choose the type of book (incoming and outgoing) and click the search button, the results of the selection appear according to the type of book

Likewise, when choosing the type of book with any other search criterion, it filters the books according to the choices

[Bob Fitz]

If you change the name of your search forms then you need to change the names in your code too.

Private Sub Command20_Click()    If IsNull(KindBook) Then
        MsgBox "Enter KindBook"
    Else
        If (KindBook) = "outgoing" Then
            DoCmd.OpenForm "MultiSearchOutGoing"
        Else
            If (KindBook) = "Incoming" Then
                DoCmd.OpenForm "MultiSearchIncoming"
            Else
                MsgBox "wrong entery"
            End If
        End If
    End If
End Sub

Indenting your code will make it much easier to follow,