Issue with searching and filtering query

[federer8]

Hi guys,
I have been stuck on this issue for quite sometime, spent 10+ hours trying to sort it out and unfortunately can't quite solve it.

I am wanting to use multiple text boxes to filter data which is given.

For example if I write in text box 1, "Asia", I want all the records with the word "Asia" to come up and then if I type in the text box 2, "India" I want all the records with word "India" in it.

Unfortunately, I have a lot to learn in access, and so I am stuck.

The problem is, I can't figure out how to filter the data, with the text box 1 being first and then text box 2 being the second one. I have tried to use:

(([Forms]![search]![srchtext]) Or ([Forms]![search]![srchtext] Is Null)) And (([forms]![search]![srchtext1]) Or ([forms]![search]![srchtext1] Is Null))

But it does not work.

Any help would be greatly appreciated,


Thanks
Adam.

[federer8]

No worries, all good. Finally figured it out, had to create another query that was linked to the first search query. And thus, the second query refined the search even more .