<div>
In this regard, listboxes work the same way that combos work. &nbsp;In the dependent listbox's RowSource include selection criteria that references the controlling listbox.<br />
<br />
Select ... From ... Where thePK = Forms!myform!lstMajor<br />
<br />
Then in the AfterUpdate event of lstMajor, requery the dependent listbox<br />
<br />
me.lstDependent.Requery<br />
<br />
Or, if you prefer, you can use any other &quot;cascading combos&quot; solution.
</div>


In this regard, listboxes work the same way that combos work.  In the dependent listbox's RowSource include selection criteria that references the controlling listbox.

Select ... From ... Where thePK = Forms!myform!lstMajor

Then in the AfterUpdate event of lstMajor, requery the dependent listbox

me.lstDependent.Requery

Or, if you prefer, you can use any other "cascading combos" solution.

<div>
Actually depends if you need to have more then one value selected, if yes then set the list box multi select property to either simple or extended and use John's suggestion otherwise set muti select to none and use it the way Pat has suggested.
</div>


Actually depends if you need to have more then one value selected, if yes then set the list box multi select property to either simple or extended and use John's suggestion otherwise set muti select to none and use it the way Pat has suggested.

<div>
<div class="content wysiwyg-content">
I would like to create a listbox row source based on a selection in another listbox.Any examples for Ms Access
</div>
</div>


I would like to create a listbox row source based on a selection in another listbox.Any examples for Ms Access

Cascading Multiselect Listbox

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.