Nancy Lytle
lytlenj at yahoo.com
Sat May 1 19:52:58 CDT 2004
I think you need to add some kind of wild card to your statement so that it is looking for kos* not just kos. Private Sub txt_names_Change() Me![list_names].RowSource = "SELECT [Last_Name] FROM [MT_basic_char] WHERE [Last_Name] like '" & Me![txt_names].Text & "*'" End Sub Nancy