mmcdonal is right about the books. And is right about the combo box.
Since you mentioned wanting to see a scrolling list you should also be aware that you can use a list box instead of a combo box.
You can also use two subforms (a.k.a. Child forms). This option is a little more sophisticated but provides more flexibility in that it is easier to display several fields in your list (another thing you said you wanted).
One subform will list your first "view" or DISPLAY PAN. When an item is selected there you'll have code that updates a hidden field on the parent (master) form. The other subform will use the master / child link fields to display data from your other table(s) according to what gets put into that hidden field.
For just a little investment of time looking at some examples of this kind of stuff, and maybe cracking open a book or two, I think you'll find great rewards in how quickly and easily Access can put together forms to present data.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group