Does anyone know how i could go about
binding two combo list boxes togther? So say
if i select a company name in the first one
the second listbox will pull up the address
in the table that coresponds to the company name.

Account Name and Address are in the same table

Private Sub ctrlAccountName_Click()

ctrlAccountAddress.DataField ???????
' I realy have no clue. I tried using SQL but
' everything i look up dosnt seem to help.

End Sub


Thanks.