filter combo box and option group and then get the results

[karinos57]

Hi,
I have this form called LOB Selection Tab. I want the user to go to this form and choose from the drop down box any selection he/she wants and then select one of the group options below like:
add to existing contract
Category unvialble and etc.....

So i want a macro or vba code that pulls the data based on the user's selection. The table that has this info is called "MainForm Tab1 Table"

Here is summary of what i am trying to say. For instance, the user selects "Surgical" from the drop down box and then selects "add to existing contract" from one of the option groups, so i want to see is the form to return only where there is only check mark has been placed in the add to existing contract field against Surgical. In other words, only filter a Surgical from the LOB field where there a check mark has been placed. I hope i am not confusing. I have already started to write some code but it does not seem that it is going well so far. Thanks in advance for your time and efforts.

[PianoMan64]

Can you please post some of your code that you've written so far and more detail as to the structure of the tables and queries. I know you have all the details in your mind, but we're kind of clueless as to what you've done so far.

Thanks,

Joe P.