Filtering the two queries in two combobox

[Aks 2010]

hello



now my problem i want make two combobox depend in diffrent queries the first combobox (brand name)filter the second combobox(models )

becouse if i make both of combobox depent in one queries
the brand name will be repeted by number of models

ex. i have three models of dell
in brand name of combobox i will have see three dell item

i try to make it with VB code but doesn't work!!
can any one help me with it??


thank you in advance...

[Aks 2010]

up
up
up
up

[dsatino]

In vba, open a recordset based on query that has the current Comp. make in the 'WHERE' statement. Loop through that recorset and the index value of the combo box and assign the recordset values along the way.

[Aks 2010]

hi dsatino

can you write the code for me
becuase today i was try to do it with recordset
but also doesn't work!!

[dsatino]

sorry, don't have time

[NeoPa]

This thread is now locked. It is a duplicate thread (which is extremely bad manners to those experts who've already tried to help you in the other thread. The difficulty there being your own unwillingness to put in even the basic levels of effort to answer questions rather than any lack of help from the experts). The other thread can be found at my problem with two dynamic combobox.

Please check out our FAQ before posting again.