This is quite a common question they are called Cascading lists
You need to set the control source of the 2nd list box to refer to the 1st
(hope that makes sense)
Something like this
SELECT TableName.FieldName FROM TableName
WHERE TableName.FieldName = [1stListName]
ORDER By TableName.FieldName;
On the AfterUpdate event of the 1st list box use this
Not an expert
Enjoy whatever it is you do
>> I want to create a list box of items for the user's selection. When the user
>> selects an item from this list box, a second list box will pop up showing the
>> corresponding values of this item.
>> How can I do that? Any examples or code will be greatly appreciated.
>> Thank you,