>>Rowsourcetype should be 'fields'. Rowsource should include alias, e.g. "table1.lname,ss_num,dob"
>>>
you just made a mistake typing Listbox.RowSource in Property Sheet. So, open Form Designer and retype it. If you are really interested to know beforehand what you really typed, then you can open SCX file manually and read record #4.
>Third, when you will type in, look at my previous replies how to do it right (it should retain alias).
Ed with all this done, correctly I believe, I cannot get the fields of my choice to show up on the listbox rather it defaults to sequential order.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."