Check boxes and option buttons VBA

[tanalea]

Newbie using Access 2010.

I've been building my first database (document control tracking) and am completely stuck trying write the code for a form using option buttons and check boxes. I've attached a mockup of what I am trying to accomplish. I need the user to be able to choose a combination of checkboxes and option buttons, then based on what they choose, the correct query is run and return in the format they select.

It's much easier to understand from the mockup attached. I can write the sql statement to query the data, but I figure out how to make any of the option buttons or check boxes work. Can this be done? Any help or thoughts would be much appreciated. I can upload a skeleton version of the database if that will help.

Thanks so much!
Tana

 

[highandwild]

I'm not exactly sure about what help you need.

Do you need to know how you can implement the rules about making selections on the form e.g. Select either 'Drawings' or 'Specifications' or both or help on taking the information on the form and putting together the Where clause for the query?