I have created a form to search in person table.  

But when I input text for searching and click to the 'Search' Button, it says Enter Parameter Value and so I input my text again and click OK, then it will work.  

Here is the code that makes this problem(another\_table created from lookup):

```
Task = "SELECT * FROM person WHERE (item1=(SELECT code_item2 FROM 
another_table WHERE name_item2=" & Me.txtSearch.Value & "))"
Me.RecordSource = Task

```