Newbie - Reading from one Access DB to load a Listbox.

[RaiderBob]

I have set up a display of an Access record. What I want to do now is, when I have to add a new record, is to read from another Access DB all the values in a certain column (via SQL) and put those values into the listbox. I am at a loss as to (1)how to do this and (2) still display the value of that column for already created records. Do I set up the field as a listbox or a Textbox, etc.?

I hope this makes sense. Any help would be appreciated.