Help needed for Parameter Search!

[john151]

Hello,

I have got a serious problem with parameter searches. What I want are multiple field parameter searches in one query. I created a new query, and set the criteria to Like "*" & [...] & "*" for at least 5 fields. The problem now is, that the number of records get less the more parameter searches i create for different fields.

I tried to put the parameters into the "or" criteria but it still does not work!

please give me a hint.

Thank you!

John

PS please ask me when you did not understand my question.

 

[john151]

Explanation>
Basically what I want to set up is a search for the user so that he can look for any information, and just has to type it in the form.

What I did until now: I have a form in Design view and make unbound textboxes. Then I create a query which looks inside of this text boxes to find me the specified information with look * & [] & *.

My problem is that when I install more that one parameter search, the query doesnt show me every record anymore. That means I can not search for every record, and just those which are shown. I think that it has to do something with relationships but I am not sure.

It would be very nice if you aswer my question,

Thank you
John