By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,962 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,962 IT Pros & Developers. It's quick & easy.

"WHERE" usage doubt

P: 47
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
Mar 26 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,492
See if you can use the ideas in Example Filtering on a Form to get you going.
Mar 26 '12 #2

P: 759

Post your reply

Sign in to post your reply or Sign up for a free account.