Synchronizing 2 Comboboxes (not The MS Northwind Style ...)

Hi There,

I want to synchronize 2 comboboxes (actually 3, but let's start with 2)

On a form I have 2 comboboxes:

- CompanyType (FK fkCompanyTypeID in table Contacts)
- Category (FK fkCompanyCategoryID in table Contacts)

Let's say we have companytype CT1 until CT10.

For CT1, CT2 & CT3 I want to choose a catagory, so the combobox must be 'enabled'.

For CT4 until CT10 the Catagory combobox must be disabled, so that I cannot choose a category value.

Actually I want to choose 2 catgories (2 comboboxes) for CT1 until CT3.
But I think that an explanation for the example above is sufficient for me.

Both comboboxes are filled by a Select Query, and the values are filled in a separate table. (Table CompanyType (PK pkCompanyTypeID) & Table CompanyCategory (PK pkCompanyCategoryID)).

Can someone please help me on this issue? :confused:

Thanks in advance for your reply,

Greets,

Quinten