Synchronizing 2 comboboxes (not the MS Northwind style ...)

[Quinten]

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?

Thanks in advance for your reply,

Greets,

Quinten

 

[RuralGuy]

Use the AfterUpdate event of the [Company Type] ComboBox.

If Me.[Company Type] = 'CT1' OR _
   Me.[Company Type] = 'CT2' OR _
   Me.[Company Type] = 'CT3' Then

   Me.Category.Enabled = True
Else
   Me.Category.Enabled = False
End If

 

[Quinten]

Thanks Rural Guy, for your anwer ...

I was thinking (again) in a way to difficult direction.





I let you know if it worked out well ...

Quinten

 

[Quinten]

And it all worked out just fine ...


Thanks again,

Quinten

 

[RuralGuy]

Glad I could help.

 

[Keidy]

help me with my problem

I have to boxes one is a combo and the other is a list
the first one show some plants like LGN or UREA
the other one when i select urea have to show me the equipments and descriptions that belongs to that plant, so if i select LGN on the combo it will show me the equipments an descriptions of that plant on the list

but really i dont know how to do it and im wasting my time trying to invent a way help please

Glad I could help.

 

[RuralGuy]

See if this link helps: Cascading Lists for Access Forms
If not then post back and we can help, but you will need to provide more details.

 

[Keidy]

thanks

that link will help me a lot thank you

See if this link helps: Cascading Lists for Access Forms
If not then post back and we can help, but you will need to provide more details.