Access Search Form that opens a Report

Need a bit of clarification.

On the Combo boxes, will each combo box be tied to one specific field and the user chooses from the available options in that field? Or will one box be tied to field names, while the other box is tied to whichever is available based on the first box? Given this, I may be able to code up a VBA answer that will generate a query.

Is the purpose of this query to update a set of records or simply review the information?

The "Function" combo box will be tied to field names such as accounting, Tax, or Risk. While the second combo box displays the code tied to the function. So if the user selects accounting only acc codes show up in the Rec Item Drop down box. The query is there just to review information and allow the user to export to excel or print it off as needed.

Thanks for the help.

I created a sample table and form which gives you a start on what you wanted. I did not pull in the text box to search the entire table as I ran out of time I can allot for this. Review the form design for the combo boxes to see where I connected them to the table. Also there is VBA code behind the form. This codes runs whenever you first open the form, update the first combo box (Field Select), and when you push the button to generate the query.

I did put brief notes in the code. You should be able to reverse engineer this to suit your needs.


SearchForm.zip

Thank you swhitesell, this is great.