Option Explicit
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\123.mdb;Persist Security Info=False"
cn.Open
Set rs = cn.Execute("select distinct city from client")
rs.MoveFirst
Do Until rs.EOF
List1.AddItem rs("city").Value
rs.MoveNext
Loop
End Sub
Private Sub List1_Click()
List2.Clear
Set rs = cn.Execute("select name from client where city='" & List1.Text & "'")
rs.MoveFirst
Do Until rs.EOF
List2.AddItem rs("name").Value
rs.MoveNext
Loop
End Sub