Search query

[ashu.doc]

Hi
I have a filter form in my application, which have certain filters, I have used different filter criterias and each criterias have search button. What I am trying to do is to use one search button and multiple criterias, but it is not working. This looks something like this -


at the moment my search form looks like this -






but i want one search button and if I enter one or more than one criterias, the query must search datas according to criterias.

thanks

[ashu.doc]

Sorry the first image was not proper

[ashu.doc]

I think I should be doing "and" in the criteria instead of writing all the criteria in same level but I dont know how can I do it?

[pbaldy]

Well, this is one method:

http://access.mvps.org/access/queries/qry0001.htm

but with that many options, I tend to use dynamic SQL, as demonstrated in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

[ashu.doc]

If I say first method is the one I can deal with because I have not got any clue about VBA and SQL. The method in the first one only solves the partial part of my question, it helps in searching in the control if some criteria is defined or if it is left blank. What I am looking for is, several controls on a page with only one query (like we see in any advance search page).

If you see the second image in my first message, there is a search button for each control, and each search button is linked to a query which is something like this

forms![form name![combobox/textbox name].

I want one search button whose query looks into all the controls in that page and give the list of data by matching the controls in database, so what I tried that I put similiar code for each field like you can see in third image, and linked it to one search button, but obviously it is not working, what I want to modify in the query is, so that it matches these controls together for one set of data, instead not search each different control and give me the list which I dont want, so using 'or ' option is not a good idea.

thanks

[pbaldy]

You would use the same technique on each field and just have one search button. I don't like it on that many fields because as you'll probably see, Access will re-orient the design grid when you save it, an it gets very confusing.

[ashu.doc]

so what is the solution, do you mean i have to put the same code as i have shown, but it is not working with one button?