filter listbox with another listbox

[zozzz]

hi everyone
As you can see in the picture I have 3 List boxes and I want to when choose the first list ، Filtered the second list box automatically.


Thank you for your help



Listbox filtering.zip

[ranman256]

The query assigned to list 2 & 3 uses the other listbox as criteria.
lst2 uses lst1

Q2:
select code from table where country=forms!fMyForm!lst1

then refresh the list once user picks an item:

sub lst1_afterupdate()
 lst2.requery
end sub

[zozzz]

excuse me my friend. can you complete the sample ?

why dos not work this code??????

Private Sub List2_Click()
Dim sql As String
sql = "SELECT Contry FROM tbl1 WHERE Contry Like '*" & List2.Column(0) & "' ORDER BY Contry"
Me.List4.RowSource = sql
Me.List4.Requery
End Sub

[orange]

See this FMS article

[zozzz]

your example for the combo box

[orange]

I have added a revised copy of the database to your zip.
Good luck.

[zozzz]

thanks orange

[orange]

You are welcome. Good luck with your project.

[Missinglinq]

your example (is) for the combo box

That's correct...but Listboxes and Comboboxes work in the exact same way, in this situation...as long as Multi-Select Property for the Listbox is set to None.

Linq ;0)>

[orange]

I agree 'linq that's why I showed the FMS combobox example. I provided a cascading listbox using the OP's data, since he/she seemed adamant to use a Listbox. As you say, either will work if one 1 selection is made.