combo boxes related to checkboxes (1 Viewer)

Hi,

i'm quite new in Access and VB.

i have a form with two check boxes and many combo boxes. I would like to filter choices in combo boxes depending on those check boxes. I have quite lots of data in tables but all of them can be sorted in two types (thats why i have two check boxes).

For example, let's say that one check box is "fruits" and other "vegetables"

If I check only "fruits" check box, I want that every combo box display only list of data for fruits
If I check only "vegetables" check box, I want that every combo box display only list of data for vegetables.
And if i check both "fruits" and "vegetables" boxes, i want to see all list for both fruits and vegetables.
----
What should i add to the code that if i check none of boxes, i get the same result as if i check both boxes (list of both fruits and veg)?
And what should i add to the code if i check none of boxes, that i get blank combo boxes everywhere?

Can that thing be done, and how exactly? I say again, i'm new with access and vba, but understand basics how to make forms, queries, some macros...

Thank you

I think you will have to write VBA code