Subform based on query help

[bjreb]

I hope there is a way to do this.

I would like to have a subform populated by a combobox in the main form.

Table Vendor
Vendor Name
VendorID

Table Items
VendorID
BrandID
BrandName

I would like to select the vendor in the main form and have the subform populate with all brands associated with the Vendor ID.

Here is the rub

I would like to have the brand names in the subform have check boxes associated with them.

Example:

Vendor 1 has two items
I would like to pull down the combo box to vendor 1 and have two check boxes with the item names as lables.

I would then like to pass the checked items to a query to view all information associated with the brands.

I know as the Vendor combo changes the number of associated checkboxes will change. I have no idea how to do this.

Thanks for you time

Andy