Filter based on two combo boxes.

[jakeao]

I'm kind of a newb so please bear with me.

I want to filter equipment issues in a multiple items form by using 2 combo boxes, and a button. Here is an example.

I want to search every issue with the Packer on Line 1. I choose line 1 from the first combo box, which then filters the second combo box. I then choose the packer. I now want to click the button and have it show only those records that pertain to the line 1 packer. Let me know if this doesn't make sense. I've tried searching the web, but I can't find anything that makes sense. Thanks.

[June7]

See if these help.
http://datapigtechnologies.com/flash...combobox2.html
http://datapigtechnologies.com/flash...earchform.html