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

How to filter a form using a Combobox on another form

P: 2
I am having problems with attempting to filter a form based on criteria
selected in a combo box from another form. I am attempting to filter a form called "Ford CheckList" that is based on a table called "Ford Returned Warranty Parts List". I am using the catagory "Program" that is in a combobox called "Program_Combo" which is located on a form called "Ford Database: Choose an Option". I want the user to open the form "Ford Database: Choose an Option" select the program they want from a combobox which in return will open a filtered version of "Ford CheckList" form with respect to that program.

I am new at this so i will need clear and step by step direction. Thank you
Mar 31 '08 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
I am having problems with attempting to filter a form based on criteria
selected in a combo box from another form. I am attempting to filter a form called "Ford CheckList" that is based on a table called "Ford Returned Warranty Parts List". I am using the catagory "Program" that is in a combobox called "Program_Combo" which is located on a form called "Ford Database: Choose an Option". I want the user to open the form "Ford Database: Choose an Option" select the program they want from a combobox which in return will open a filtered version of "Ford CheckList" form with respect to that program.

I am new at this so i will need clear and step by step direction. Thank you
look at the docmd.openform help section in Access. You can pass criteria to the opening form telling it what to filter on.

example:

DoCmd.OpenForm "Employees", , ,"LastName = 'King'"
Apr 1 '08 #2

Post your reply

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