How to filter a form using a Combobox on another form

[viranadim]

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_Co mbo" 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

[JConsulting]

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_Co mbo" 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'"