Why is this form with multi field search box not working?

[mfhaq77]

[FONT=&quot]Hi everyone,

I am a new member of this forum.

Please be helpful to me.

I have created a Form with multi field search box. To execute this I made a Query

But i am not getting any result.

Going through the attached file, could you please tell me where the problem is.

Here is the file

Thanks in Advance

Fazlul[/FONT]

 

[CJ_London]

you are using additional double quotes

Like "“*”" & [Forms]![SearchF]![NameTeacher] & "“*”"

these need to be removed then your query will work

 

[GrunleStan]

its your Condition in your query...
from
Like "“*”" & [Forms]![SearchF]![DesigTeacher] & "“*”"
to many quotes double quotes.

change it to
Like "*" & [Forms]![SearchF]![DesigTeacher] & "*"

as a matter of fact when typing the criteria in to Access, leave out the "", the Design window will help you add enough in to it.

 

[GrunleStan]

same answer a minute a part !!

 

[arnelgp]

here you may try

 

[mfhaq77]

Thanks to All for your kind and Quick Cooperation.
Special thanks go to @Arnelgp who has taken trouble to remake the file for me


I have a question here.
Is it possible to place the query result just beneath the Form?

 

[arnelgp]

of ciurse you can

 

[mfhaq77]

of ciurse you can

Thank you for your useful effort.
Would you please explain in a few words how to place the query result just beneath the Form? Alternatively you can refer me to a web or video tutorial.

 

[arnelgp]

i put the query in the subform. you can google whay is a subform.