I have a combo box based off a table on a unbound form with a listbox the field in the list box is column(3) what is the code I need to Select a name in the combo box and have it display all records thdat pertain to that name. I feel this has been covered before I just dont remember.

---

Reply from Richard Rost:

There are a couple of ways to do it. You could use an AfterUpdate for the Combo Box to rewrite the RowSource of the List Box:

MyListBox.RowSource = "SELECT * FROM WhateverT WHERE SomeID=" & ComboBoxValue

Or you can base a query criteria on the combo box value (Forms!WhateverT!ComboBoxValue) and then use that query as the RowSource for the List Box, just .Requery it when the combo box is changed.

I prefer the first method. :)

If you want me to figure out which courses I covered this stuff in, let me know... or you can use the SEARCH page, or the ACCESS INDEX.