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
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
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:
Code:sub lst1_afterupdate() lst2.requery end sub
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
your example for the combo box
I have added a revised copy of the database to your zip.
Good luck.
thanks orange
You are welcome. Good luck with your project.
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
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.