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

mfhaq77

New member
Local time
Tomorrow, 04:03
Joined
Sep 7, 2018
Messages
3
[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]
 

Attachments

you are using additional double quotes

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

these need to be removed then your query will work
 
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.
 
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?
 
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.
 
i put the query in the subform. you can google whay is a subform.
 

Users who are viewing this thread

Back
Top Bottom