"WHERE" usage doubt

[rwalle]

I have a "MainForm" containing a "SubForm", the SubForm is based on a Query and the MainForm has unbound comboboxes and TextBoxes to built filters that I apply to Subform using buttons in MainForm, it works fine, now I'd like to do this same filtering action but using the query criteria , I have done pointing the query design gird criteria fields to the MainForm combos and Text Boxes, it also works , but I'd like to know how to do this from VBA so I can use only one "Main" query and then build different WHERE clauses dependig on what I'm looking for , I have seen some examples but it's not so clear for me , could somebody point me to some examples of how to build this kind of filters / queries ?

Thanks for the help

[NeoPa]

See if you can use the ideas in Example Filtering on a Form to get you going.

[Mihail]

Or the ideas from http://bytes.com/topic/access/answer...y-filter-query