I have a form with 5 combo boxes which combined represents the employeeID and by using a parameter query im able to extract any data from the employeeID. Now what i want to do is to do the same function and but instead of typing a parameter i want to use the combo box and display the data in a subform or subreport. Heres the schema to the very best of my description. cmb1 - e - c - f cmb2 - CO - JS -AM cmb3 - 000 - 001 - 002 cmb4 - XX - PF cmb5 - NO - AA an example employeeID would be cco000pfaa. now yesterday im able to query this by just using the Like feature in criterea (exp: "Like "*" & [Enter EmpID] & "*" ) and by typing CO and data would be extracted by employeeID with the value CO and would output it on a datasheet. I would like to do this same function using combo boxes and the output would display in my subform/subreport in my form. I hope for people who read this can understand what im talkin about. Any help would be great.