By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,441 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

Filtering the two queries in two combobox

P: 13
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...
Aug 10 '10 #1
Share this Question
Share on Google+
5 Replies


P: 13
up
up
up
up
Aug 10 '10 #2

dsatino
100+
P: 393
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.
Aug 10 '10 #3

P: 13
hi dsatino

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

dsatino
100+
P: 393
sorry, don't have time
Aug 10 '10 #5

NeoPa
Expert Mod 15k+
P: 31,769
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.
Aug 11 '10 #6

This discussion thread is closed

Replies have been disabled for this discussion.