MS Access 2013 Query Error (1 Viewer)

I have been working on some queries of MS Access 2013 but i am getting some errors, i applied this query but its says "Enter the parameter value" :banghead: any help would be appreciated.
Like "*" & [Forms]![Master List of PMA Membership Form]![SR#] & "*" but it does not returns all the value, while pressing on search button from the Form Page and in my Excel table some values are empty some contains value. In earlier project i tried this query it worked fine, but in this case i don't know why its not working. I am Uploading a sample table database & picture for reference.

mediafire.c0m/download/amggh44o7i7ld29/Database3.accdb

Welcome to the forum

1. How are you running the query?
2. Is the form open (and remains open) before and when you run the query?
3. What is the SQL of the query?

1) well i created a criteria as i mentioned in my earlier post. and run it from the form page.
2) off course i have to open form to search my desired value.
3) i am not using SQL but the sql generated in my database with the criteria i used is this

SELECT [Master List of PMA Membership].[SR#], [Master List of PMA Membership].[EN#], [Master List of PMA Membership].Name, [Master List of PMA Membership].[Father's Name], [Master List of PMA Membership].Address, [Master List of PMA Membership].Phone, [Master List of PMA Membership].[Cell No:], [Master List of PMA Membership].[e-mail address], [Master List of PMA Membership].[NIC No], [Master List of PMA Membership].Qualification, [Master List of PMA Membership].Category, [Master List of PMA Membership].Reference
FROM [Master List of PMA Membership]
WHERE ((([Master List of PMA Membership].[EN#]) Like "*" & [Forms]![Master List of PMA Membership Form]![EN#] & "*") AND (([Master List of PMA Membership].Name) Like "*" & [Forms]![Master List of PMA Membership Form]![Name] & "*") AND (([Master List of PMA Membership].[Father's Name]) Like "*" & [Forms]![Master List of PMA Membership Form]![Father's Name] & "*") AND (([Master List of PMA Membership].Address) Like "*" & [Forms]![Master List of PMA Membership Form]![Address] & "*") AND (([Master List of PMA Membership].Phone) Like "*" & [Forms]![Master List of PMA Membership Form]![Phone] & "*") AND (([Master List of PMA Membership].[Cell No:]) Like "*" & [Forms]![Master List of PMA Membership Form]![Cell No:] & "*") AND (([Master List of PMA Membership].[e-mail address]) Like "*" & [Forms]![Master List of PMA Membership Form]![e-mail address] & "*") AND (([Master List of PMA Membership].[NIC No]) Like "*" & [Forms]![Master List of PMA Membership Form]![NIC No] & "*") AND (([Master List of PMA Membership].Qualification) Like "*" & [Forms]![Master List of PMA Membership Form]![Qualification] & "*") AND (([Master List of PMA Membership].Category) Like "*" & [Forms]![Master List of PMA Membership Form]![Category] & "*") AND (([Master List of PMA Membership].Reference) Like "*" & [Forms]![Master List of PMA Membership Form]![Reference] & "*"));





i need all the fields searchable in this database lyk data collection bank, u knw it contains more than 5000 entries its hard to find any individual value, so i need to create a form in addition with the table so that, if i search with any thing i type, it shows me all the relative data details and further more if i need to add some more data in it so it should be possible. this is wat i want to do.

Can you please answer all three questions in the same order.

1) well i created a criteria as i mentioned in my earlier post. and run it from the form page.
2) off course i have to open form to search my desired value.
3) i am not using SQL but the sql generated in my database with the criteria i used is this

SELECT [Master List of PMA Membership].[SR#], [Master List of PMA Membership].[EN#], [Master List of PMA Membership].Name, [Master List of PMA Membership].[Father's Name], [Master List of PMA Membership].Address, [Master List of PMA Membership].Phone, [Master List of PMA Membership].[Cell No:], [Master List of PMA Membership].[e-mail address], [Master List of PMA Membership].[NIC No], [Master List of PMA Membership].Qualification, [Master List of PMA Membership].Category, [Master List of PMA Membership].Reference
FROM [Master List of PMA Membership]
WHERE ((([Master List of PMA Membership].[EN#]) Like "*" & [Forms]![Master List of PMA Membership Form]![EN#] & "*") AND (([Master List of PMA Membership].Name) Like "*" & [Forms]![Master List of PMA Membership Form]![Name] & "*") AND (([Master List of PMA Membership].[Father's Name]) Like "*" & [Forms]![Master List of PMA Membership Form]![Father's Name] & "*") AND (([Master List of PMA Membership].Address) Like "*" & [Forms]![Master List of PMA Membership Form]![Address] & "*") AND (([Master List of PMA Membership].Phone) Like "*" & [Forms]![Master List of PMA Membership Form]![Phone] & "*") AND (([Master List of PMA Membership].[Cell No:]) Like "*" & [Forms]![Master List of PMA Membership Form]![Cell No:] & "*") AND (([Master List of PMA Membership].[e-mail address]) Like "*" & [Forms]![Master List of PMA Membership Form]![e-mail address] & "*") AND (([Master List of PMA Membership].[NIC No]) Like "*" & [Forms]![Master List of PMA Membership Form]![NIC No] & "*") AND (([Master List of PMA Membership].Qualification) Like "*" & [Forms]![Master List of PMA Membership Form]![Qualification] & "*") AND (([Master List of PMA Membership].Category) Like "*" & [Forms]![Master List of PMA Membership Form]![Category] & "*") AND (([Master List of PMA Membership].Reference) Like "*" & [Forms]![Master List of PMA Membership Form]![Reference] & "*"));





i need all the fields searchable in this database lyk data collection bank, u knw it contains more than 5000 entries its hard to find any individual value, so i need to create a form in addition with the table so that, if i search with any thing i type, it shows me all the relative data details and further more if i need to add some more data in it so it should be possible. this is wat i want to do.

Welcome to the Forum!

I would use this...
http://allenbrowne.com/ser-62.html

Much easier to manipulate and update should I need to expand.

For next time, it's best you create a new post rather than editing the old one so there's no conflict between my post and yours.

hubbak said:

2) off course i have to open form to search my desired value.

Click to expand...

So what does this have to do with Excel?

Copy and paste the SQL statement into a query and see if you get the values.

Edit: I see Gina has given you a standard solution. Best to use that if it's a search form you're after.