Changing rowsource of 2 listboxes based on 3rd listbox.

Changing rowsource of 2 listboxes based on 3rd listbox.

I have 3 listesboxes cboDiv, cboMtrType and cboJobCat.
i.e.
cboDiv is electric, water, sewer (range = Div)

cboMtrType is ElecRes, ElecCom, ElecInd…, WaterRes, Water1, Water2… (range name = MtrType) (FYI, there are no sewer meters)

cboJobCat is Electric Line Down…, Water Main Burst…, Sewer Main Blocked… (range name = JobCat) (FYI about 50 each division)


Since each division has its own set of meters and jobs, I want to make a separate range for each of their meter types and jobs, based on the Division.


All the Meter Types are in a single list now, as are the Job Categories but I want to separate the meter types into 2 ranges, one for electric and another for water (ranges Emtr and Wmtr), and the JobCats into 3 separate ranges, one each for electric, water and sewer (Ejobs, Wjobs and Sjobs).
Then based on the division selected, I want just the related meters and jobs in the respective listboxes.

I think I can do this with changing the rowsource of cboMtrType and cboJobCat based on the selection of cboDiv, but don’t have a clue as to how to build the code.

Your help is APPRECIATED, Thanks, Phil

bump

Do I need to attach the wkbk?


I saw this on the board a few months ago (I think), but can't find it...

Thanks for the all the help!
Phil

Took 3 days but I figured it out.

Saw a 'case' use several weeks ago, copied it to a word.doc for reference and adapted it. Thanks to whoever answered that guys question.

Please Login or Register  to view this content.