Question Search records based on multiple check boxes

[maytricks]

Hello! I'm not very familiar with access, but I know it can do what I want - just need to figure out how.

Okay, here's the question:

I have a table of data regarding companies (contact info, etc). The company I work for provides these companies with up to 10 different products. On my input form, I have created 10 check boxes (and thus, 10 columns of Yes/No data in the corresponding table).

Each company has at least 1 product checked off, and up to all 10.

I would like to create a combo box that lists all 10 products, and upon selecting one, a list box then populates with the names of the companies (primary key) that use that specific product.

So, for example,
Company A buys CATS and DOGS from us
Company B buys DOGS
Company C buys CATS and ELEPHANTS

Combo box options: CATS, DOGS, ELEPHANTS

If I choose DOGS, then a list box gets populated with:
Company A
Company B
and when I click either of these, the record should be brought up for the respective company.

All of this should take place in the header of the form, while the form itself can be updated based on search selections.

It doesn't seem like an overly complicated thing to do, it's just that I don't have much experience in Access and haven't had a ton of luck doing the usual searching.

Thanks for your help!

 

[John Big Booty]

Welcome to the forum.

Whilst this sample is not exactly what you are looking for it should give you a good starting point.

 

[maytricks]

Thanks Actually I went through that post during my searches and while it did put me in a step toward the right direction (reference search string & list box creation), I am still completely lost as to how to handle the multiple checkbox values

 

[maytricks]

What if I try querying a different field in the database based on the value selected from the combo box in the form - is this possible?

SELECT tblCom.[Company Name]
FROM tblCom
WHERE (((tblCom.[Forms]![frmCom]![cmboProduct])=True));

This doesnt work, but could this work in a different way?