conditional listbox

[×¢× ×‘×œ]

hello,
I would like to make 2 list box.
whenever I choosr value from the first the secind will give same opisions
and if I choose different value in tje first list box, the second will give
me other choices.
I hope it is understood.
Thank you,
Inbal

 

[Al Campagna]

Inbal,
Given two listboxes, lstState and lstCity, use the value of lstState to
filter the results in lstCity.

On my website (below) I have a sample file called Synched Combo boxes
which demonstrates how to do that.
(it would be the same method for a list box as a combo box)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."